Want to Stop Rebuilding "Expensive" Parts of your Flow? Explicit Builds are the Answer!READ MORE

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
Dataiker

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
Dataiker

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.