Row count with transformer.

kennyapril · Post by **kennyapril** » Wed Aug 03, 2011 8:20 am

I have a field customerInfoID which has duplicates like 101,101,101,101,102,102,102.
The output I need is 101,4 and 102,3 i.e row count of each customerInfoID.

This can be done through aggregator but I wanted to do this in transformer to avoid using aggregator

please suggest me the function which has to be used

Thanks

vinothkumar · Post by **vinothkumar** » Wed Aug 03, 2011 8:41 am

I think there are no specific functions to do this in transformer. You have to use StageVariables along with transformer.

kennyapril · Post by **kennyapril** » Wed Aug 03, 2011 9:12 am

In the stage variable do I need to find the count of Rows or how can I do it?

Thanks

chulett · Post by **chulett** » Wed Aug 03, 2011 9:55 am

It's basic 'group change detection'. You increment a stage variable each time you see the same 'group'. For a new group, you set the count back to 1.

Leveraging the Sort stage with a 'Key Change Column' will simplify this for you.

vinothkumar · Post by **vinothkumar** » Wed Aug 03, 2011 12:33 pm

Use remove duplicates stage and keep the last one.

kennyapril · Post by **kennyapril** » Wed Aug 03, 2011 4:00 pm

That works!!

Thankyou All