DSXchange

Ray what u said is true, I used a sort stage before a RD and it worked and when I used inlink sort(RD) it wouldnt work, So I compared the OSH for both jobs and thats whew it was a silly mistake...

Saravanan, it had nothing to do with Handling Nulls, thanks for your help.

Hi Ray sorry, it was a stupid mistake, I was hashing and sorting on all 2 fields when I should be hashing on field A and Sorting on fields A and B..
Thanks

I handled Nulls before the RD and it still wont give me correct results...

Hi all, I'm removing duplicates, and sorting both my input fields one of which is Nullable. eg; colA(NotNull) colB ( Nullable) 10 N 10 Y 10 Null when I sort on both col A and B and say keep nulls last for col B, and remove duplicates based on A, the output is 10 N and 10 Null when I should be gettin...

Thanks Ray Appreciate your help !! I'll stick to PX questions hereafter.

Hi all, I have this problem.... File1 consists of Key1 and Key2 Fields
File2 consists of a group key and Key3 fields.

If both key1 and key2 exist within a group (field key3 in file2) then delete those recs from file1.

wats the best way of doing it in PX.

Appreciate ur help !!