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
2 REPLIES
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.