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?

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

[SH_94]

Hi @ messi007

I couldn't open the file. 

May i know how i use the interface tool?

Could you briefly explain?

[messi007]

@SH_94,

Could you tell me which Alteryx version you use?

you can find examples here:

You can open the .yxwz file throw :

Regards,

[SH_94]

Hi @ messi007

I use the Alteryx version as shown below

Can i still use the way u suggest?

[messi007]

@SH_94,

Please try open the attached workflow from Alteryx File -> Open -> Browse -> the attached the workflow

Hope this helps,

Regards,

[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

[messi007]

@SH_94,

Below my comments,

Attached the workflow,

If this solve you're need please make it as solved it will help others

Regards,

[SH_94]

Hi @ messi007

May i know how i use the action tools - meaning what are the things i need to update?

Also, could you guide me how to import the file inside ? Which button or functions i need to click?

Thank you