In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Export Excel tabs into separate File

DanielCarro
8 - Asteroid

Hi guys,

 

I need some help as I am struggling to get through.

 

So I have a spreadsheet with several country tabs 'Austria' 'Belgium'  'France', etc and each country need to be saved as a separate file which is located in a location, so Austria shall go into file B:\ABC\ABC Compliance\Alteryx\ABC drive output\Output\AT,  Belgium will be the same path but \BE and France will be \FR, and so on.

 

I have read some posts but each one are slightly different and I tried to work on it but haven't succeeded. I tried using the Dynamic tool but didn't work out.

Much appreciated any guidance.

 

DanielCarro_0-1682011648927.png

 

 

Kind Regards,

Dan

4 REPLIES 4
binuacs
21 - Polaris

@DanielCarro One way of doing this

binuacs_0-1682017699761.png

 

DanielCarro
8 - Asteroid

Hi Binuacs,

Thank you for your response. The issue is that I don't have a column called 'Country' but the tab named by country. Instead of 'Country', is it possible to use 'Sheet Name'?

 

 

DanielCarro_0-1682026829074.png

 

Although the first cell appears as:

DanielCarro_1-1682027096873.png

In alteryx appears as:

 

DanielCarro_2-1682027162121.png

Any thoughts?

binuacs
21 - Polaris

@DanielCarro Updated the workflow and attached

binuacs_0-1682075370630.png

 

also, update the formula inside the macro to get the correct file name. I only updated 3 countries and the abbreviations

 

binuacs_0-1682076458195.png

 

DanielCarro
8 - Asteroid

Hi @binuacs , it worked. Thank you very much

Labels
Top Solution Authors