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!
I am using the window recipe to compute rownumber.
I am only getting rownumber as the column in my ouput.
How do i make the output have the same columns as the input plus the rownumber?
I already figured it out. The answer is to RETRIEVE the columns in the AGGREGATE step.
HI,
could you please explain how you added a simple rownumber column to a table/dataset?
If i give an order column it repeats numbers n times (based i guess on the order column i set).
I would like to have a simple rownum column different for every row.
Thanks,
Raffaello.