I am trying convert my client data into our standard structure using a mapping file. If there is 1:1 mapping, the logic works well using Dynamic Rename tool. If I have the same source field mapped to multiple target fields, I cannot get through using Dynamic Rename tool.
PS: I can achieve the result using Transpose, Join and CrossTab. That's not an option. I have 2 Million rows and 300 columns.
Attached workflow with sample data and expected result
