Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Files read

CloudDuck
7 - Meteor
Hello,

I need assistance with the following issue. I have a macro that helps me fill in some details within a blob template. The macro works more or less as intended. In my 'Example workflow', I would like to use the macro and also incorporate a directory containing multiple .xlsx files. I need to create a macro that will take the output of the blob macro and the path where the .xlsx files are saved, read them, and allow the user to select which sheet will eventually be appended to the blob file. I'm not sure how to do that since the output of the blob is already saved. I suppose I need to modify the initial blob macro, but I can't pinpoint what needs to be changed. I have attached a FinalOutputExemp.xlsx for reference for the final output representation.

 

 

1 REPLY 1
apathetichell
19 - Altair

Your use case is a chained app. select a file. Select a sheet = chained app. app 1) - select file. get list of sheet names. 2) app 2 - populate drop down from sheetnames of app 1 - generate drop down - update blob/template. 

Labels
Top Solution Authors