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
Solved! Go to Solution.
Follow up questions:
Why are you forcing a duplicate field for "a"? alteryx will rename with a numbered suffix for all duplicate fields.
Do you know which fields you want to duplicate? - if so, you can duplicate them from the source and then rename your mapping to be unique.
I am not forcing duplicate names. Source represents column names from my client files and Target represents column names from my table. I am trying to map Source columns to my Target. At times, the same source column is mapped to more than one Target column. There is no duplicate column naming here.
that's odd. Alteryx should be forcing a rename as the fields are coming through. (Alteryx doesn't like duplicate field names) Is that not happening?
@jarrod Source has only one column named 'a', But I am mapping that column to more than one column in Target(A1, AA1). Hope this clarifies.
Thank You @jarrod