This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I am creating an Alteryx workflow that has the directory tool and then the Dynamic input tool to pull all xlsx files from the specified path. However, The last 2 columns in each file have a different name. There are 12 files in all and the last column name changes from Jan 2020 XXXXX to Dec 2020 XXXXX. The dynamic input tool works fine and unions all the 12 files however throws multiple Warning messages.
Is there a way I could change the columns names (for the last 2 columns) before they are being dealt by the Dynamic Input tool.
Then I have attached a Macro example which should work in your example. Your workflow will look similar to as it does now, but instead of the Dynamic Input, you will use the new Macro.
Within the Macro, you firstly need to enter a template file (1 of the 12 files), the next step is using a Dynamic Rename to update specific fields based on a Formula. I have used an IF statement which looks if a Field Name contains a certain string, in your case this would be the 'XXXXX'. It will then produce an output with all files stacked on top of each other.