topic Re: tMap - Numeric.sequence in Talend Studio

tMap - Numeric.sequence

jimbo20814 — Sat, 16 Nov 2024 03:09:04 GMT

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)

Re: tMap - Numeric.sequence

Anonymous — Fri, 28 Feb 2020 01:44:34 GMT

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

Regards
Shong

Re: tMap - Numeric.sequence

TRF — Fri, 28 Feb 2020 11:07:57 GMT

Did try the following expression:

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

Re: tMap - Numeric.sequence

jimbo20814 — Fri, 28 Feb 2020 21:38:37 GMT

Bam! Thank you TRF!

Re: tMap - Numeric.sequence

TRF — Fri, 28 Feb 2020 22:21:51 GMT

Bam Bam!
You're welcome