Discover the winners & finalists of the 2022 Dataiku Frontrunner Awards!READ THEIR USE CASES

add an incremental column in dataset

Solved!
deep_215
Level 2
add an incremental column in dataset

 requirement is to add an incremental column in datset, it should not be an identity column however data in it will be unique.

0 Kudos
1 Solution
Manuel
Dataiker Alumni

Hi,

You can use a Window recipe for this:

  • In the Window definition, enable a order column
  • In the Aggregations definition, compute the Row Number
  • See attached image

For an overview of the Window recipe, check :

I hope this helps.

View solution in original post

1 Reply
Manuel
Dataiker Alumni

Hi,

You can use a Window recipe for this:

  • In the Window definition, enable a order column
  • In the Aggregations definition, compute the Row Number
  • See attached image

For an overview of the Window recipe, check :

I hope this helps.