DSXchange

Yes you can do it using remove duplicate followed by join stage. I sorted the records such that i get the maximum id on top ad retain first record. use a copy stage before the remove duplicate. Take anther link from there which has all the records. now use inner join with maxid as the key.it will gi...

Thanks Grimm , Grace and Sasikaran for your replies. I tried using remove duplicate and Join stage and i am getting the desired output..... I treid aggregator as well. And thanks ray for your suggetion. I could resolve it with the help of dsxchange and without contacting official support provider. I...

I have few records like this

11, A,B,C
11,A,B,C
10,A,B,C
10,A,B,C
9,A,B,C

suppose the first column is ID. i need all the records which has the maximum id for the combination of 2nd,3rd and 4th column.
My output should be
11,A,B,C
11,A,B,C

how do it do it? Please help. Its urgent

Please let me know how to extract latest datastage job logs from the director using unix shell scripting.