Forum Discussion
srikotla
7 years agoNew Contributor
Thank you So much sarathmattam,
I’m able to achieve this using mapper in the following way.
-
Read the data in sorted order
-
Generate the sequence
-
Copy the data into two outputs
-
For one o/p, Use Aggregate to find the min sequence grouping on the cost_center
-
From other o/p join the data using the cost_center
-
Use Mapper, and in one of the port define the logic as : (Value - min_Seq)+1
Here Value is the sequence generated from the sequence snap
Min_Seq is the minimum sequence value of the respective group obtained from aggregate snap.