Batch macro help - missing sheet

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.

Batch macro workflow CLEAN.yxzp

Batch macro workflow HELP.yxzp

Batch Macro

Accepted answers

MichalM

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.

Batch macro example.yxmc

All comments

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703