Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Import and Combine xlsb file from multiple subfolder

SH_94
11 - Bolide

Hi Community,

 

May i know if anyone have the macro that can read the xlsb file from multiple subfolder and import them into the Alteryx whereby i plan to combine them together in Alteryx as they have the same schema.

 

 

Appreciate if you can provide the screenshot on how to modify the macro so that the macro will identify and read the subfolder correctly. It would be great if anyone have the macro which cover importing and combining the data in xlsb file.

15 REPLIES 15
TomWelgemoed
12 - Quasar

Hi @SH_94 ,

 

Did this work out for you in the end?

SH_94
11 - Bolide

Hi @TomWelgemoed ,

 

I still figure it out how to fix this.

 

Overall, i guess i know what should i do with the files before importing it into the Alteryx. However, i would like to seek your advice on what is the best approach to build comprehensive and versatile workflow.

 

Currently, i have the following file with different scenario:

1. Files with different format ( certain files in the form xlsx , xlsb or csv).

2. Certain file have the same schema and other files does not have the same schema. For those that have different schema, we have the consistent header (but with different position in the excel)

3.As i plan to put in the subfolder if there are multiple of files within the country. Hence, some files are in the subfolders and others are not in the subfolders.

4.Some files have only one excel tab in the excel sheet, but some files have multiple of tabs in the excel sheet (but i am aware of which tabs to be imported into the Alteryx).

5.For all the tabs imported into alteryx ( i plan to add it under one column no matter whether it is originally coming from one single tab of excel sheet or multiple tabs of excel sheet)

 

Considering the five points above, can i seek your advise/ suggestions how should i categorise it when building the workflow so that it is easier to differentiate in the alteryx.

 

Many thanks again for your help

SH_94
11 - Bolide

Hi @pedrodrfaria ,

 

Yes. I already move the files into the desktop and it seems working now.

 

Can i just confirmed with you on the following items?

1. Can this macro read xlsb file which contains multiple tabs with different schema or only applicable for same schema?

 

Thanks again for your help.

 

 

 

pedrodrfaria
13 - Pulsar

@SH_94 

 

Yes, it would open multiple schemas.

SH_94
11 - Bolide

Hi @pedrodrfaria ,

 

Thanks a lot for the information.

 

I would like to ask whether the alteryx macro can read the respective excel tab name and make it into the new column field.

 

As i understand that alteryx can read the file name and change it into the another new column if we change the output file name as shown in the screenshot below.

 

May i know can alteryx macro do the same for different tab of the excel file and populate it into the new column field?

Jacob_94_0-1615584794874.png

 

SH_94
11 - Bolide

Hi @pedrodrfaria ,

 

Sorry for disturbing you again and i not sure why the error appear again as below:

 

Jacob_94_0-1615999064404.png

 

 

Jacob_94_2-1615999134835.png

Could you please advise me on this? 

 

Labels