Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2011-10-10 06:42 AM

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
Labels (2)
Labels
448 Views
0 Likes
3 Replies
Sebastiao_Qlik
Employee
Employee
‎2011-10-11 10:06 AM

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.
448 Views
0 Likes
Anonymous
Not applicable
‎2011-10-11 10:58 AM
Author

check out this thread: https://community.talend.com/t5/Data-Quality-Preparation-and/Using-User-Defined-Indicators-over-mult...
It will give you some idea how to do it.
448 Views
0 Likes
Anonymous
Not applicable
‎2019-10-16 09:29 AM
Author

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

448 Views
0 Likes