Issues using macros to merge multiple sheets with different schema

[Yeonsujen]

Hi All,

I'm a complete beginner and need some help with using macros to merge multiple sheets with different schemas. I have read other forums and tried to follow step by step guides but I keep running into the same problem.

I was given the following workflow and macro to use in the "ReadSheets.yxzp" file for a sample Excel file. Please also refer to the "Output File.xlsx" I was trying to achieve.

However, I am now trying to apply this workflow and macro for a different file. I have tried to change the file on the "Reader.yxmc" macro and used the first sheet as a sample (just like the original macro for the "Amy Green" sheet):

When I run this on the "ReadSheets.yxmd" workflow, it doesn't pull all the data from the different Excel sheets and only repeats from the first Excel sheet in the macro file:

I run into the same problem when I try to apply this to any sample macro and I'm not sure what the issue is.

I'm also not sure how to add a blank preparation tool to connect a macro when I create a new workflow (I need to do this for different Excel files and merge the sheets together on a monthly basis). Does this mean I need to create a new macro for every new workflow and copy+paste the tools from the previous workflow?

[afv2688 · Accepted solution]

Hello @Yeonsujen ,

I just opened the file you sent to the forum and seems to be working on my side.

The only thing I can think of that might have happened is that you somehow changed the selection on the action tool for the parameter to be replaced or changed (in this case the sheets) and that would be what affected the result. If that changed that would mean that the sheet is not replaced since it is not chainging the value and therefore would use always the one selected on default, in this case Amy green.

Please check that the tools has the same configuration as on this image. Be careful of blank spaces too, those affect also (it is also case sensitive).

Hope that helps

Regards

[Yeonsujen]

Hi @afv2688,
Thank you for your response!

I have just double-checked and you are correct! On the action tool, the selection was unticked and I didn't replace "Amy Green" with "A Steinle". I now have the following for the "Reader.yxmc" macro:

This has removed the error on the blank preparation (reader) tool from my workflow and I can now see all outputs for my list of sheet names! Thank you so much 🙂