tMap - Numeric.sequence

[jimbo20814]

Hi, I'm trying to duplicate SQL row_number. I know that for example the tMap Numeric.sequence(row1.col1,1,1) would be equivalent to SQL ROW_NUMBER() OVER (PARTITION BY row1.col2) but what if there are multiple fields to partition by? For example, ROW_NUMBER() OVER (PARTITION BY row1.col2, row1.col2, row1.col3)

[Anonymous]

@mbocquet, can you please show us an example to explain your requirement and what are your expected output?

Regards
Shong

[TRF · Accepted solution]

Did try the following expression:

Numeric.sequence(row1.col1+"_"+row1.col2+"_"+row1.col3, 1, 1) 

[jimbo20814]

Bam! Thank you TRF!

[TRF]

Bam Bam!
You're welcome