eg: consider the following data-set
Now in the target dataset/table, we require a new column which would sequentially assign a number starting from 1 for each student under a particular class. The result set then would look something like below,
Now we have this new column (StudentSeqNbr) which sequentially numbers each student under a particular ClassId. The aim is to create such a sequential column using SAP BODS.
Solution: SAP BODS has an inbuilt function which will let you create such a sequence and can be mapped inside a Query transform.
|Gen Rownum function in SAP BODS( Click to enlarge )|
Using this function and the below syntax, a sequence can be created for the scenario above.