Alteryx Designer

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

Input multiples xlsm files

Highlighted
Alteryx Certified Partner

Hello 

 

I'm trying to open several xlsm files from a directory but I can't find a way to do so.

 

I now it's easy for xslx files but that xlsm format bother me. 

 

Those files contains multiples sheets but I only am interested in one sheet (named "Output")

 

I'm looking for a way so I wouldn't have to manually convert the files type to the xlsx format

 

Is there a way to do so?

 

Thanks!

 

 

Highlighted
Alteryx Certified Partner

Fixed x)

 

Simply with replacing the file name in the input tool by *.xlsm and then after choosing the table

Highlighted
Alteryx Partner

Hi @Hakimipous,

 

for your problem, actually Alteryx can open several xlsm data files in one time. but in order for you to do so, you need to follow this instruction:-

1- Each files should have same name (Eg: test1, test2, test3)

2- Connect the first file with alteryx using input tools as usual and locate the sheet you want to select.

(Eg: file-test1, sheet-Output )

3- After you select the first file, you change the location at Connect a File or Database from test1 to test*

4- then hit run o see the result.

This way, you does not need to change your file format. Just make sure the name is same by adding 1,2,3 at the end of the file name. Hope this solution may help you.

Highlighted
Alteryx Certified Partner

Thanks ! I'll try this one too

Labels