Multiple tabs output error

[Kinetic_analytics]

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

[IraWatt]

Hey @Kinetic_analytics,

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

[Kinetic_analytics]

[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. 

[binuacs · Accepted solution]

@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

[Kinetic_analytics]

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