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