LastrowinGroup function in datastage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
mvrkreddy
Participant
Posts: 12
Joined: Sun Apr 13, 2014 11:46 pm

LastrowinGroup function in datastage

Post 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
RAJESH
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Post your code - stage variables, constraints, everything involved in these checks.
-craig

"You can never have too many knives" -- Logan Nine Fingers
mobashshar
Participant
Posts: 91
Joined: Wed Apr 20, 2005 7:59 pm
Location: U.S.

Post by mobashshar »

Why you are not using Remove Duplicate Stage??
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Choose a job you love, and you will never have to work a day in your life. - Confucius
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

Surely a sort with keychange followed by a filter would be simpler, quicker, etc?
Post Reply