topic Re: File Not Found In Macro in Alteryx Designer Desktop Discussions

File Not Found In Macro

SH_94 — Sat, 15 Jan 2022 13:39:24 GMT

Hi Community,

i have build the workflow and macro as attached below but it prompt me an error message as per screenshot below:

May i know if anyone encounter this before and could you please assist me on this ?

Many thanks in advance

Re: File Not Found In Macro

atcodedog05 — Sat, 15 Jan 2022 13:36:39 GMT

Hi @SH_94

Can you share the workflow as packaged workflow so that dependencies are not broken.

Re: File Not Found In Macro

SH_94 — Sat, 15 Jan 2022 13:38:50 GMT

Hi @atcodedog05 ,

Many thanks for the reminder.

Please find the attached packages for your reference.

Re: File Not Found In Macro

atcodedog05 — Sat, 15 Jan 2022 13:49:10 GMT

Hi @SH_94

It seems to work for me. Is this the same input file used ? Are you getting error with this file too?

Hope this helps : )

Re: File Not Found In Macro

SH_94 — Sat, 15 Jan 2022 13:53:19 GMT

Hi @atcodedog05 ,

Yes..I not sure what happen to my alteryx and it prompt out error message when i open from packages file

Is there anyway to fix the error normally?

Thank you.

Re: File Not Found In Macro

atcodedog05 — Sat, 15 Jan 2022 13:57:20 GMT

Hi @SH_94

This message is reading file lock. Please close all input files before running workflow.

Hope this helps : )

Re: File Not Found In Macro

SH_94 — Sat, 15 Jan 2022 14:02:23 GMT

Hi @atcodedog05 ,

Sorry i also just notice that..Basically what is the issue here is i would like to import all the sheet into the alteryx.

As you can see in the result, it only import for the first sheet...This part i not really sure why it does not import second sheet as well.It duplicate the same tab instead of importing the second tab.

Thank you.

Re: File Not Found In Macro

atcodedog05 — Sat, 15 Jan 2022 14:03:25 GMT

Hi @SH_94

Not sure try this workflow for the task.

Hope this helps : )

Re: File Not Found In Macro

SH_94 — Sat, 15 Jan 2022 14:08:34 GMT

Hi @atcodedog05 ,

May i know if the workflow able to accommodate the following scenario:

1. Different sheetname

2. Different schema for each sheets

Would like to ask, if marco able to read password protected excel file?

Many thanks for the help.

Re: File Not Found In Macro

atcodedog05 — Sat, 15 Jan 2022 14:12:17 GMT

Hi @SH_94

Answer to the questions

1. Different sheetname? Yes

2. Different schema for each sheets? Yes

3. Would like to ask, if marco able to read password protected excel file? No

Hope this helps : )

Re: File Not Found In Macro

SH_94 — Sat, 15 Jan 2022 14:29:44 GMT

Hi @atcodedog05 ,

I try the macro file and may i ask do i need to specify the sheet and how can i do that for this part?

Thank you

Re: File Not Found In Macro

atcodedog05 — Sat, 15 Jan 2022 14:45:08 GMT

Hi @SH_94

It works for me and able to get both sheets. Refer attached workflow.

Also I could from your screenshot your system doesn't have enough processing space (Refer yellow highlighted below). You may want to close some applications and try again.

Hope this helps : )

Re: File Not Found In Macro

SH_94 — Sun, 16 Jan 2022 08:55:15 GMT

Hi @atcodedog05 ,

May i know how can i extract the information of sheet name and file name by using this macro?

Thank you.

Re: File Not Found In Macro

atcodedog05 — Sun, 16 Jan 2022 09:09:58 GMT

Hi @SH_94

Try this updated workflow.

Hope this helps : )

Re: File Not Found In Macro

SH_94 — Sun, 16 Jan 2022 09:14:48 GMT

Hi @atcodedog05 ,

May i ask for the following screenshot, do we need to tick the replace a specific string? May i know what information need to put for the column under the replace a specific string? Can we put the same as the one in circle?

Re: File Not Found In Macro

atcodedog05 — Sun, 16 Jan 2022 09:25:43 GMT

Hi @SH_94

May i ask for the following screenshot, do we need to tick the replace a specific string? Yes

May i know what information need to put for the column under the replace a specific string? Full path and file name excluding the sheetnames refer highlighted below

Can we put the same as the one in circle? Yes

These are placeholders. This macro wouldn't need any change it should work where it's placed with whatever input folder path you give.

Hope this helps : )

Re: File Not Found In Macro

SH_94 — Wed, 09 Feb 2022 17:10:59 GMT

Hi @atcodedog05 ,

May i ask if you know how to solve the error below?

Thank you