hi guyz,
having a bit of issue achieving the following
source:
1
1
1
2
2
3
3
3
how to get the following
1 1
1 2
1 3
2 1
2 2
3 1
3 2
3 3
is there any built in function in ds that can achieve that. i tried my best, couldnt find any.
generating sequantial numbers
Moderators: chulett, rschirm, roy
DSGuru2B,
you can solve this type of problem by using stage variables. The first stage variable is called SeqNo and have the derivation "IF (In.NumberColumn=LastNumberColumn) THEN SeqNo+1 ELSE 1" and the second is called LastNumberColumn and is derived with "In.NumberColumn". This depends on your source being sorted on your In.NumberColumn; but since that is what your sample shows I'll assume that this is the case.
you can solve this type of problem by using stage variables. The first stage variable is called SeqNo and have the derivation "IF (In.NumberColumn=LastNumberColumn) THEN SeqNo+1 ELSE 1" and the second is called LastNumberColumn and is derived with "In.NumberColumn". This depends on your source being sorted on your In.NumberColumn; but since that is what your sample shows I'll assume that this is the case.
</a>