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

[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]