Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
requirement is to add an incremental column in datset, it should not be an identity column however data in it will be unique.
Hi,
You can use a Window recipe for this:
For an overview of the Window recipe, check :
I hope this helps.
is it possible to do this in the prepare recipe? not that I don't know how to use window but would like to keep all changes consolidated in a single recipe if possible
Using a python code step in a prepare recipe:
count = 0
def process(row):
global count
count += 1
return count