add an incremental column in dataset

[deep_215]

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

[Manuel · Accepted solution]

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 :

[video]

I hope this helps.