add an incremental column in dataset

deep_215
deep_215 Registered Posts: 9 ✭✭✭

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

Tagged:

Best Answer

  • Manuel
    Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭
    Answer ✓

    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.

Answers

Setup Info
    Tags
      Help me…