Import multiple excel file with different name without downloading any third party marco

[SH_94]

Hi ,

I would like to combine 3 excel file with the same field for these three files. May i know is there any way i can compile it in the Alteryx without downloading any marco?

If i didn't put it into one folder, can we manually choose from the Alteryx?

[messi007 · Accepted solution]

@SH_94,

to understand the action tool Alteryx examples is you're best friend:

In this case you don't have to modify the action tool as it will update the file input from the interface tool.

To run the workflow and update the files you have to run the workflow like below:

1- Run as Analytic APP

2- Choose the file

3- choose the sheet

4- finish to see the result

Attached the last version of the workflow,

Regards,

[SH_94]

Hi @messi007

May i know why my other functions show the symbol as shown below? For instance, there is lightning symbol and others.

May i know if this will impact the result ?

[SH_94]

Hi @messi007 ,

Thanks a lot for your help and It work well in this case . I have two queries as below and would like to seek for your guidance.

1. May i know if i want to import more than 3 files, will this workflow still work and how can i modify it to increase the number of files imported. The number of files uploaded could be different for different project. Can i make it more dynamic workflow ?

2. Secondly, may i know how can i make the result below appear in the canvas alteryx ? As it have been separated from the alteryx.

[messi007]

Hi @SH_94,

1. May i know if i want to import more than 3 files, will this workflow still work and how can i modify it to increase the number of files imported. The number of files uploaded could be different for different project. Can i make it more dynamic workflow ?

 ==> If need the user to choose the file you have to create more input files, if not you can use input folder in order to ask the user to specify the folder and then you read the requested files

You can do this using macro

2. Secondly, may i know how can i make the result below appear in the canvas alteryx ? As it have been separated from the alteryx.

You can do it by activating the interface designer from the view menu 

Select proprieties :

Hope this helps,

Regards