You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » hao to express ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY ...)
#1 2011-10-10 11:42:44
- Joe
- Member
- Registered: 2011-01-07
- Posts: 102
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
Offline
#2 2011-10-11 15:06:47
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.
Thank you for your support,
Sebastiao Correia.
Offline
#3 2011-10-11 15:58:27
- mreuter80
- Member
- Registered: 1970-01-01
- Posts: 59
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.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » hao to express ROW_NUMBER() OVER(PARTITION BY ComboID ORDER BY ...)