Using Datastage, how would you go about looping through a set of columns as if they were rows?
For instance, given a text file, with the following fields: OrderNumber Item1Code Item1Qty Item2Code Item2Qty Item3Code Item3Qty etc...
I want to insert a new row into an orders table for each new OrderNumber (for each row in the text file) and insert a new row into an items table for each ItemCode that is not null.
Any help is appreciated,
Anthony