assing values

IBMDS · Post by **IBMDS** » 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

ray.wurlod · Post by **ray.wurlod** » 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.

kduke · Post by **kduke** » Mon Jun 16, 2008 4:54 pm

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

ray.wurlod · Post by **ray.wurlod** » Mon Jun 16, 2008 6:43 pm

Apparently it was from IBM (short for IBMDS).