Excel Sheets Different Schemas _ Help Understanding "The Ultimate Input Doc"

[sslattery17]

I have read the following - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/The-Ultimate-Input-Data-Flo... ; however, I still have not been able to resolve my issue with sheets being different schemas.

1. I have tried using Formula with Output column FullPath and the following [FullPath]+"|||Sheet1$"

Each month client sends reports we audit; sometimes their sheets are named with property name (Madera at NorthBank) other times just sheet 1 as an example.

2. Cannot seem to get the maco configured to work either..

I am 3 weeks into using this tool figured out a long watching videos and reading.  But I am lost on this one. Any additional guidance would be great.  

[sslattery17]

I have set the action tool to match the path and tried it both ways as noted no data is pulling

[binuacs]

@sslattery17 it should work, are you getting the full file path from the first macro?

[sslattery17]

It appears so...The fp shows the sheet names....also just to confirm; the second macro should have the path where all the files are correct?  so I am assuming the File1 sheet 1 is looking for the first on the file directory and should be bringing in the columns in the sheets?

 

[sslattery17]

It appears so...See below.

The fp shows the sheet names....also just to confirm; the second macro should have the path where all the files are correct?  so I am assuming the File1 sheet 1 is looking for the first on the file directory and should be bringing in the columns in the sheets?

 

[binuacs]

that is correct, in the second macro are you passing the fullpath as argument

[sslattery17]

Yes.  It is pulling an error for one of the files.

 

[binuacs]

Can you make sure file which is showing in the error message is not corrupted 

[apathetichell]

Is that error at runtime or on canvas? Look at your browse tool going into the macro - do you have that file/sheet combo? If the error is occuring because the original file the macro was set up with uses that file/sheet - and you (the user) do not have it - it should clear once run.

[sslattery17]

Sorry for the delayed response.  Network went down. 

Issue Resolved.  Thank you again for your support, time and help. 

The sheet was not corrupt, for some reason the data cleansing left a space at the end of that sheet name so manually deleting it; resolved the error and the pathway error resolved by putting all the remaining workflow in a disabled container.