Hi! This is my first time posting, I want to say thank you all for your constant support to the community. So much great content on here.
Currently, I'm facing an issue where I'm reading in data from a bunch of Excel files with different formats (different formats come in monthly) and my requirement is that I need to rename columns based on rules in a master data table.
For example, here's my master data table:
Source | Replacement
Customer Number | Entity Code
Customer No | Entity Code
Now, say I have a unioned data set like this:
Customer Number | Customer No | Value
1000 | null | 1542.50
1500 | null | 1329.40
null | 1115 | 1379.39
null | 1200 | 1448.45
How can I get it to be updated to this format?
Entity Code | Value
1000 | 1542.50
1500 | 1329.40
1115 | 1379.39
1200 | 1448.45
It's also okay if the previous column headings are still in there, this is just an example. I've also attached an example Alteryx flow for this if it's any help. It currently isn't working because it's matching on the same "Replacement" column multiple times. Any advice would be greatly appreciated - thank you!
