DSXchange

Posted: **Thu Apr 15, 2010 8:47 am**

Use transformer sate and stage variable.

Thanks

Posted: **Thu Apr 15, 2010 8:54 am**

You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.

Posted: **Thu Apr 15, 2010 8:56 am**

ArjunK wrote:You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.

If you remove duplicates, you cannot have multiple. So the count will not be more than 1.

Posted: **Thu Apr 15, 2010 9:12 am**

Sainath.Srinivasan wrote:
ArjunK wrote:You can remove dups on all four keys and then just aggregate on all four. Where ever the count is greater than 1 set record as 'MULTIPLE'.
If you remove duplicates, you cannot have multiple. So the count will not be more than 1.

My bad. Remove duplicates of four and then aggregeate on the first three.

DSXchange

Computation