BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ashley5
Calcite | Level 5

Hello - Is there a way to generate a sequence column in a dataset using the point and click functionality in enterprise guide?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
Calculated field using the MONOTONIC() function.

View solution in original post

3 REPLIES 3
PhilC
Rhodochrosite | Level 12

No. There is not a specific Task that does that particular thing, that I know.  There's a way to do it using Query Builder, and there's an easier way to do it using a Program note and a data step.  

 

At the time of this posting, this website had examples of a data step like the one you need.

The counter _N_ (nyu.edu)

Ashley5
Calcite | Level 5
What is the way in Query Builder? That might work for me. Thank you!
Reeza
Super User
Calculated field using the MONOTONIC() function.