How to add a new column in (Row ID) which is sequentially increasing

Hi Team,
I attached one picture for your reference, here I want to see the row id columns in auto increment format.
Auto Increment Row Id

Hi @Biswajit_1993 -

See the solution here and how to generate a row number using the Rank function.

1 Like

@robdhondt could you please write the exact formula for this? actually I am not understanding it properly.

Hi @Biswajit_1993 -

Sure, here’s the calculated field and example.

row_id

rank([concat({column_name},{data_item_descr}, attr) ASC],[],PRE_AGG)

1 Like