DSXchange

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

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

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


Thanks

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.

Use remove duplicates stage and keep the last one.

That works!!

Thankyou All