Page 1 of 1

LastrowinGroup function in datastage

Posted: Tue Sep 09, 2014 3:05 am
by mvrkreddy
hi ,

I need to group three coulms to check in lastrowingroup function..how can i check this function...

The main reason is i have one column with duplicate records ..so i filtered with lastrowingroup function in transform...but i missed few records which are also needs to process.so i need to check three columns in lastrowingroup..means if three coulmns are same in two records then it should take last record

Posted: Tue Sep 09, 2014 7:20 am
by chulett
Post your code - stage variables, constraints, everything involved in these checks.

Posted: Tue Sep 09, 2014 11:43 am
by mobashshar
Why you are not using Remove Duplicate Stage??

Posted: Tue Sep 09, 2014 6:42 pm
by qt_ky

Posted: Tue Sep 09, 2014 9:29 pm
by stuartjvnorton
Surely a sort with keychange followed by a filter would be simpler, quicker, etc?