Scenario to achived rownumber function in sql
How can I achieve rownum() funtion in Snaplogic?
I have a input data
Column 1
a
b
c
a
a
need output
Column1 Column2
a 1
b 1
c ...
Forum Discussion
rownum based on some partition by column. In this case I want the output based on column 1. thats why it is 1,1,1,2,3
Sorry, can you please explain more specifically what you mean by that? What is the partitioning rule?
