Row splitter error

[myukassign]

I am getting the following Error while using row splitter. would it be possible fro anyone to help me out?

RowSplitter..Row_Splitter_4: read_delimited() - row 1, column Mark, required column missing

I do the following Steps

1. Sequential file Input which has two coloumns, will look like this. Both declared as VArchar 100

"'Arun':'Jose':'Koottungal'","100"
"'Tony':'John':'Dinu'","200"

2. Point to Row splitter

Row Splitter Input Stage

Multiple Lines box not checked
Selected columns to split as "Names" (i.e. first column)
Input columns are the same of sequential file.. i mean same defnition

Row Splitter output Stage

Delimiter :
Quote Character '
Null string not specified anything
Missign column message : Fatal
output column, i declared 4 columns Name1 Varchar Name2 Varchar
Name3 Varchar Mark Varchar

3. Sequential file Target. Same columns given in output i mena 4 columns.

I debug the program, the minute it is failingin row splitter.


Note: If I change the missing column action to "None" in the row splittter stage output format, the job is running very fine, the string is deviding to exacly 3 names and pushing to the output file. But if i turn on this to warning or fatal the job getting abort. I doono wht is going on.

[chulett]

You declared four columns but only seem to have data to populate three, so the fourth column Mark is "missing" if it can't split out data for it. And then you told it to kill itself when that happens.

[myukassign]

But you look in to the data i am supplying.

It will split the first line to 3 column and the last one(mark) just need to pass through the stage.

There is no chance of not getting data for all columns.

Do you think am i doing somthing wrong ?

[chulett]

Note: If I change the missing column action to "None" in the row splittter stage output format, the job is running very fine, the string is deviding to exacly 3 names and pushing to the output file.

My comment is based on your comment highlighted above. When you changed the action to 'none', are all four columns populated or just three as you note above?

I don't believe the Row Splitter has a 'pass thru' functionality but hardly ever use it so could easily be wrong...

[myukassign]

All four columns populated so nicly.........

That is the point of all confusion for me.......