DSXchange

ray.wurlod wrote:An approach using stage variables may be found here

I am unable to see the replies.

Thanks

i tested this and its working..it may . Hi Pavan, I am having like 20000 rows in the input and like 30 columns.The method you had shown me seems to be little bit complicated thats y i preferred asking for stage variables.Anyway can u just give me some more idea like while aggregating what should be...

pavankvk wrote:i have another solution for this problem.i will not use stage variables though.

hth

Its not working that way pavan.

Thanks

deployDS wrote:Please explain your logic. What is the basis for rejecting those 2 records?

I am rejecting those two rows because the POS is not same for that particular ID.

For the given ID the positions should be same orelse reject that complete set.

Thanks

Hi can someone help me in defining stage variables for a simple logic. I am having the input as: No Pos 1 A 1 A 1 A 1 A 2 B 2 C 3 D 3 D 3 D 4 C And i need o/p to be No Pos 1 A 1 A 1 A 1 A 3 D 3 D 3 D 4 C Reject 2 B 2 C I am pretty new to datastage.Anyhelp is appreciated. Thanks siri