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

[Biswajit_1993]

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

[robdhondt]

Hi @Biswajit_1993 -

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

SumOver -Summing distinct entries from a table with duplicate rows

Hi @Ummehaani - Here is an alt. solution, if you don’t have any true duplicate rows in your dataset but rather duplicate values (Customer Name). You can approach this in the analysis without data prep/ETL. Note: You want to weigh the cost of the window functions if you are working with a large dataset (rows and columns). You can also generate row number in your ETL (for this example I kept everything at the analysis level) [image]

[Biswajit_1993]

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

[robdhondt]

Hi @Biswajit_1993 -

Sure, here’s the calculated field and example.

row_id

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

[Samiksha]

But what is the alternate of this ?? because I have more than 30 columns in a dataset I cant use concat or rank function