I have attached input file and desired output how i wanted.
Kindly please help me.
Note - NEW_SRN column indicated how many times same number is been repeated based on that prefix is added _1, _2 etc...
Solved! Go to Solution.
@Surajnair take at the workflow attached that should help. Let me know how you get on