Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

How to add an auto incrementing id column?

UserBird
Dataiker
How to add an auto incrementing id column?
This seems like I'm overlooking something simple, but I can't find how to create a new column for a CSV dataset that has an auto-incrementing id. I'm sure it can be done in Python and SQL, but I'm not really proficient at them and it would be nice to just have it as a step in the sidebar instead of a whole new recipe. Does this exist? Thanks.
0 Kudos
1 Reply
Clรฉment_Stenac
Hi,

The easiest is to use the "window" recipe, and enable the "rank" aggregation. Note that in order for this to work, you'll need to declare a sorting column.
0 Kudos

Labels

?
Labels (2)
A banner prompting to get Dataiku