topic Re: hao to express ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY ...) in Data Quality

hao to express ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY ...)

Anonymous — Sat, 16 Nov 2024 12:38:07 GMT

Hi all
I just want to know how to express the function of ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY SolutionDescription) in talend.
I realized this function in tMSSqlOutOut by sql before,but now,I should realized it via talend component.
Waiting for you advice,and thank you very much.
Best Regards
Joe

Re: hao to express ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY ...)

Sebastiao_Qlik — Tue, 11 Oct 2011 14:06:47 GMT

Hi Joe,
I advise you to create a user defined indicator in which you can write your own SQL template and then use this indicator in a column analysis.

Re: hao to express ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY ...)

Anonymous — Tue, 11 Oct 2011 14:58:27 GMT

check out this thread: https://community.talend.com/t5/Data-Quality-Preparation-and/Using-User-Defined-Indicators-over-multiple-columns-duplicate/td-p/101688
It will give you some idea how to do it.

Re: hao to express ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY ...)

Anonymous — Wed, 16 Oct 2019 13:29:14 GMT

https://faihofu.blogspot.com/2019/10/talend-rownumber-functionality-using.html
is this blog post any use?

it uses tMap to mimic the tsql row_number() over (partition by....) windows function