Window Recipe - Add a rownumber to the input

rainierms19

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?

rainierms19

I already figured it out. The answer is to RETRIEVE the columns in the AGGREGATE step.

rafgiordy

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.