Batch macro help - missing sheet

[cireost]

Hi - I created a simple example of batch macro to illustrate my issue.  I have three excel files (Property A, B, C) and within each file, there are several tabs (Summary, Expiration, Rent).  All the workflow is doing is pulling data from each of the tabs.    However, Property C does not have a "Rent" tab.  As such, the batch macro fails.  In my real life example, I cannot predict if a given tab will be present in an excel file.  If it is not present, I would like the results to be null for that tab.  I have attached 2 examples below.  The CLEAN example is assuming all tabs are present.  The HELP example is if the tab is missing.   Any help would be greatly appreciated.

[MichalM]

@cireost 

You can change this behaviour by opening Interface Designer (View > Interface Designer) and navigating to Properties of the macro. Make sure that the Output mode is set to 'Auto Configure by Name'.

[cireost]

i just tried and think i am still having this issue.  any chance you could edit the workflow for me?

[MichalM]

My bad - I jumped the gun here. Any chance you could share the files with me so I can have a look at the structure? 

[cireost]

I thought when i exported the workflow that it would include the input files.  but here you go!

You'll notice that Property C does not have a "Rent" rab.

Thanks!

[MichalM · Accepted solution]

There are couple of things that need addressing on top of the change I already suggested - change the Output mode in the macro properties to 'Auto Configure by Name'. Then

1. We need to make sure that if there's no 'Rent' sheet, the Input Data which expects it is disabled. This can be achieved by adding it to a container and disabling that container if the string coming in is empty

2. And also that the last Append Fields is skipped unless there's data. This can be achieved by leveraging Detour -  the workflow will go Left if there's no 'Rent' sheet and Right if it's there

Attached is the updated macro. 

[cireost]

Thanks! I am taking a look now. Did you have to make changes to this workflow?  This was the workflow built to allow users to read from a directory where each of the property excel files are located.

[MichalM]

No. I've only changed the second macro.