Is there any function in BODS to generate a row sequence, but you cann't use Key_Tansfertion transform

[former_member214007]

How to generate a row sequence (using function) without using Key_Generate transform

[Former Member]

Use gen_row_num() function for this. This is a built in fuctions of designer. Jst use this in any Query transform and get the row number generated automatically.

[former_member211387]

There are gen_row_num() and gen_row_num_by_group() functions that can be used to automatically generate row numbers from a query transform.

If you are using a roe_generation transform, you can specifiy the number of rows you need and the DI_ROW_ID column will have an auto-generated row number as per the settings specified.

kind regards

Raghu

[Former Member]

Use gen_row_num() function.

[Former Member]

Use Gen_row_num() built in functions which is available in Data services designer

[Former Member]

Use gen_row_num() function

[former_member187605]

Use the key_generation built-in function.