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

One Star

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

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
Employee

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

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.
One Star

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

check out this thread: http://www.talendforge.org/forum/viewtopic.php?id=17584
It will give you some idea how to do it.
Five Stars

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

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read