DSXchange

How can I solve the below error. "XFM: Error when checking operator: No input sort key information found. Keys being checked: record ( XXX: string[6]; ). Input data must be sorted with the keys that are passed to key-break function calls. If input data has already been sorted, a sort stage need...

I am aware that I will have to use stage variables. But it looks like its not a simple solution. I might have to use looping as well as functions and a generic solution. Could you please alleviate the solution to me with stage variable pattern looking at the example above.

That will just give me the Rtno where Cno=0 and Dno=0. My requirement is that, I need the First Rno, for Every same Pno(Dupes) where Cno=0 and Dno=0. Like in the below example if dno=0 and cno=0 then for every pno=222 I need rtno=123. Rno Pno Dno Cno rtno 123 222 0 0 123 321 222 1 2 123 213 222 2 1 ...

I have the following table. Rno Pno Dno Cno 123 222 0 0 321 222 1 2 213 222 2 1 432 111 0 1 342 111 1 0 562 333 0 0 721 444 0 0 271 444 1 1 Ouput Rno Pno Dno Cno rtno 123 222 0 0 123 321 222 1 2 123 213 222 2 1 123 432 111 0 1 null 342 111 1 0 null 562 333 0 0 562 721 444 0 0 721 271 444 1 1 721 For...