Running Sequence Number in SAP BODS

[former_member1043171]

Hi ,

My req:- I’m merging 3 tables, And need to pass running sequence. These running sequence will be order wise like first table row numbers then second table rows then 3table sequence.

Please give me some solutions ..

[rajan_burad]

Hi Gowtham,

As far as I can understand your requirement, you have 3 tables merged and you want a sequence number based on table names. Like if you've 10 rows for table_x, then you want sequence number 1 to 10. If you've table_y with 30 rows then you want sequence number 1 to 30. for this table and same with third table.

Solution:

Before merge transform use a query transform and add 2 columns, "Table_name" and SEQ_ID.

For Table_name column, map your table names.

For SEQ_ID, map it with gen_row_num()

After merge transform use another query transform and do order by.

You'll get the sequence numbers based on table names.

Let me know if it helps!

Thanks 🙂

[former_member208402]

Hi Gowtham,

Your requirement is not clear, could you please elaborate more with an example?