DSXchange

Hi .

I am trying to read a file which has column no_occur and fo(n) columns.
The no_occur column contains the number of field from which the data is to be assigned to the target field.

e.g if the no_occur = 30. I have to read from fo30 column ( skiping column fo1 to f029).


Thanks,
Gokul

Can you provide us an example and then , in plain words, tell us what your output should be.
And is going to be an update?

You can read the line as a single VarChar and parse that in a Transformer stage (probably the easiest). You could also parse it in a Column Import stage.