Window Recipe - Add a rownumber to the input

rainierms19
Level 2
Window Recipe - Add a rownumber to the input

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?

 

2 Replies
rainierms19
Level 2
Author

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

rafgiordy
Level 1

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.

0 Kudos