Free Trial

Alteryx Designer Desktop Discussions

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

Read multiple Google Sheets with batch macro

vlad_kutateladze
8 - Asteroid

I am trying to read multiple Google Sheets. I have read all available discussions in community and always batch macro recommended as solution. I created one which accepts workbookID as parameter. It works, by changing workbookID in input batch macro changes file accordingly. But when I put list of workbookID I can get only one file from the top of the list.  How can I get all of them?   

 

vlad_kutateladze_0-1628763302481.png

vlad_kutateladze_1-1628763413465.png

vlad_kutateladze_2-1628763602909.png

 

vlad_kutateladze_3-1628763820389.png

 

 

 

2 REPLIES 2
AkimasaKajitani
17 - Castor
17 - Castor

Hi @vlad_kutateladze 

 

Please connect the any tool to output anchor of macro.

If you don't connect to the output anchor of the macro, Designer will judge that the repeat is not needed.

 

 

 

vlad_kutateladze
8 - Asteroid

@AkimasaKajitani Yes, it helps. Thank you! 👍

Labels
Top Solution Authors