DSXchange

Posted: **Mon Jun 16, 2008 2:45 pm**

how to assign '1' for minimum line number and all the remaining line numbers to '0'.

I have to derive the column 3 based on the column1 and column2

Column1 column2 column3
100 1 1
100 2 0
100 3 0
100 4 0

Thanks

Posted: **Mon Jun 16, 2008 4:47 pm**

Sort the data by Column 1 and Column 2 and have the Sort stage generate a key change column into Column 3.

Posted: **Mon Jun 16, 2008 4:54 pm**

Ray, I am not sure I would of answered this based on the topic.

Posted: **Mon Jun 16, 2008 6:43 pm**

Apparently it was from IBM (short for IBMDS).

DSXchange

assing values

assing values