Reading a speciifc occurance

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Gokul
Participant
Posts: 74
Joined: Wed Feb 23, 2005 10:58 pm
Location: Mumbai

Reading a speciifc occurance

Post by Gokul »

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
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

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?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply