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

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?

Common Use Cases

Accepted answers

messi007

@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,

ReadFiles.yxwz

All comments

Qiu

@SH_94
If you are Ok with manual operation, drag 3 files in to Cavas then click a few times.

messi007

@SH_94,

You can use interface tools in order to do that:

Attached the workflow,

Hope this helps,

Regards,

ReadFiles.yxwz

SH_94

Hi @ messi007

I couldn't open the file.

May i know how i use the interface tool?

Could you briefly explain?

SH_94

Hi @messi007,

i can open the workflow that u sent just now.

May i know what are the things that i need to change ? Could you briefly explain how i use the function tool below for those circled in black colour as shown in the screenshot below

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167