Free Trial

Alteryx Designer Desktop Discussions

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

Macro for Multiple input files with different Sheets name

kauser
8 - Asteroid

Hello,

i am working in a workflow and there are multiple inputs files (around 15) and each of these file have single and/or multiple different sheets with different data. How can i create a macro that will help to bring all these file along with sheets name then i can mapped data from these sheets into different places on my workflow(as requirement). i am not combining or piling data from all these different sheets into one. i have found multiple articles and examples but all of these are compiling/piling data from all different sheets into one. For example here i illustrate list of my all input files along with different sheets name 

 

File Name                                                                                                                                          sheet name

ASIA INDIA
 CHINA
EUROPEUK
 NI
AMERICAUSA
 CA
AFRICA EG

 

My expectation is how can i get all these sheets name and then also how can i map data from each one of these sheet into my workflow. 

 

INDIA
CHINA
UK
NI
USA
CA
EG

 

I also tried with Dynamic input tool without Macro then i got error message "check your path" and/or " file is corrupted" 

2 REPLIES 2
kauser
8 - Asteroid

@Qiu  this are not answering my question because i am trying to bring different sheets from different input files. 

Labels
Top Solution Authors