Hi - I've tried to put together a macro to make it easy for new Alteryx users to use dynamic input by using an excel mapping file. However, when I run the workflow in the Macro vs use the macro in a workflow I get different results - though the inputs haven't changed.
The macro return a dynamic input with File and Sheetname - as the standard tool would do - but the list of files is provided in an excel format.
I can't for the life of me work out what's causing this and any helpy would be appreciated.
DEdge
Solved! Go to Solution.
Hi @drdedge
Can you attach some the excel input files that you reference in your macro
.\Input\Example Input Files\2015.xlsx|||Sheet1$
.\Input\Example Input Files\2016.xlsx|||Sheet1$
.\Input\Example Input Files\DifferentSheetName.xlsx|||2018$
.\Input\Example Input Files\Other DIrectory\OtherDirectory.xlsx|||Sheet1$
.\Input\Example Input Files\TwoSheets.xlsx|||2019$
.\Input\Example Input Files\TwoSheets.xlsx|||2021$
Dan
Whoops - updated with the zip file including it all.
dAve
Hi @drdedge
You were so close. In the action tool connected to the "Please input the template file name and directory", you highlighted the "Output file name" attribute as opposed to the "File" attribute
With this change the results are identical
Dan