Parse Error for sheet name

[SH_94]

Hi Community,

Currently, i am trying to try the macro and it appear the error as per screenshot below . May i know how we can fix this error so that the workflow can be run?

Thank you so much for your help.

[echuong1]

It doesn't look like there is a field called "Sheet Names" available. Can you try removing and re-adding? If you click on the X, you can see the fields you have available.

[SH_94]

Hi @echuong1 ,

Thank you for your prompt response. It seems like the existing column showing header column in the excel file instead of showing the file name or sheetname. Do you mind if i send the workflow for you to have closer look ? As i try to fix some of the restriction and build more dynamic formula in this case.

[echuong1]

Yes, are you able to upload a copy of your workflow and sample data?

[SH_94]

Hi @echuong1 ,

Sure. Kindly refer to the attached sample data for your reference.

Basically, below are the things that i try to achieve in this workflow:

I had inputted two macro to read the files within in the different subfolder (xlsx format) and read different file names. However, when i copy these two macro into new workflow , i notice that the macro does not read the all the files inside the folder and read different file names. I not sure which part had gone wrong in this process. Can you please help me have a look on the macro whether it only applicable for certain cases ?

Just would like to highlight that the macro built above was to read different schema or same schema of file. Will this impact the above result whereby macro does not working?

The macro was to built to achieve the following task:

1.Read all the excel file within different subfolder and read the all the excel file name and multiple tab. The excel file could be different schema and same schema sometime.

2.After the macro captured all the information from different excel file, i would like to request the Alteryx to read the file name by splitting the filename into useful information with the concept below. The concept of splitting the file name will be the spacing between the words or number. However, if exceed more than column 3, no need to read the information.

Above will be the overall concept that i plan to build but i not sure which part that i have made wrong which cause the error to appear.It would be great if you can help me to check on these two macro if anything that i made wrong .

[SH_94]

Hi @echuong1 ,

I also attached the marco again for your reference as i not sure it is being zip under the yxzp in the previous file.

Thank you.

[echuong1]

If you are just trying to split out the components of the file name, you can use a text to column.

I've configured this to parse using a space. Any additional instances past 3 will be removed automatically.

[SH_94]

Hi @echuong1 ,

Thank you for the prompt response. May i know how to fix the error before we come to the text to column stage? I follow this formula based on the previous macro solution post.

Based on your review, will the two macro able to perform the step 1 before coming to the step of text to column?

Thank you