DSXchange

Split the three columns into five columns using a Transformer stage (derivation expressions using Field() as discussed above), then use a Pivot stage. Manual for the Pivot stage is Pivot.pdf and is in the Packages folder of your DataStage client CD. It has good examples. Welcome to the forum, Tony;...

There's usually multiple ways to solve any problem, but the simplest thing for this situation would be to use FIELD. From memory: FIELD(DATA,",",1) -> Col1 FIELD(DATA,",",2) -> Col2 etc You tell it the string to parse, what the seperator is and which occurance you want. -craig H...