How to separate column level duplicates in BODS ?

[nallamprashanth]

How to identify the column level duplicates and populate them in the target table?

[vijayb · Accepted solution]

Hi Prashanth,

You can use gen_row_num_by_group or is_group_changed function by adding all columns or specific columns in group and populate the records by filtering out the group >1 into separate target table for duplicate values.

Thanks,

Vijay

[nallamprashanth · Accepted solution]

Thanks Vijay Sir.