how to generate sequence numbers

vijaya · Post by **vijaya** » Thu Sep 14, 2006 10:12 pm

I needed to generate sequnce number like

a-1
a-2
b-1
b-2

how can we do in datastage

ArndW · Post by **ArndW** » Wed Sep 20, 2006 8:08 am

Use stage variable in a transform stage

Variable: "ACount", derivation "IF In.Column="A" THEN ACount + 1 ELSE ACount
Variable: "BCount", derivation "IF In.Column="B" THEN BCount + 1 ELSE BCount

That gives you a numeric value for subsequent occurrences of a string and you can do the rest from that.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 2:54 pm

Make sure that the data are appropriately partitioned, so that all values in each group occur in the same partition. Otherwise you will get broken sequences.