Scenario to achived rownumber function in sql

[dipanjan_pan]

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 1
a 2
a 3

How can I achieve this?

[ptaylor]

Sorry, can you please explain more specifically what you mean by that? What is the partitioning rule?

[ptaylor]

The expression snap.in.totalCount might be what you’re looking for, but I’m really not sure based on your example.

[viktor_n]

Hi @dipanjan.pan,

I hope this will help you 🙂
SnapLogic_Community_2021_05_31.slp (7.2 KB)

Regards.

[dipanjan_pan]

Thanks a lot @viktor_n …it works