Multiple tabs output error

Hello:

Good afternoon. I have used the Block Until Done tool and Output tool. Unfortunately, I am getting errors. Could you please enlighten me to fix the error? Appreciate your help.

I meant two TABs output. Summary tab 1 and tab 2 in a single .xls sheet

multiple tabs excel ouput (2).yxmd

Workflow

Accepted answers

binu_acs

@Kinetic_analytics As @trsali mentioned you need to remove the null values from the field you selected for the sheet names, in your first output it is Customer ID and in the second output itis the Customer Name. These fields cannot be NULL if you are selecting them as your sheet names

multiple tabs excel ouput (2).yxmd

All comments

IraWatt

Hey @Kinetic_analytics,

What specific error are you getting? I cant access the data from your workflow.

Kinetic_analytics

Sample - Superstore (2).xls

trsali

What is the error that you are getting?

Kinetic_analytics

This is how I configured the output tool.

Kinetic_analytics

please check the attached file.

trsali

You must remove the null value in the Customer ID field, add a filter tool before the output tool. This is the formula that should go in the filter tool: !IsNull([Customer ID])

Kinetic_analytics

What if I want two different tabs, TAB 1 and 2. Whatever processing possible I have done that. I am not proficient in using the hold until block tool though.

binu_acs

multiple tabs excel ouput (2).yxmd

Kinetic_analytics

Sorry, I am not getting 2 tabs summary output. I have attached the output for your information.

Report.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703