Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLUCIONADO

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.

 

Kinetic_analytics_0-1658955703904.png

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

 

9 RESPOSTAS 9
IraWatt
17 - Castor
17 - Castor

Hey @Kinetic_analytics,

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

 

trsali
Alteryx Alumni (Retired)

What is the error that you are getting?

This is how I configured the output tool.

 

Kinetic_analytics_0-1658956214868.png

 

 

please check the attached file.

 

Kinetic_analytics_0-1658956308829.png

 

trsali
Alteryx Alumni (Retired)

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])

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
Polaris

@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

 

binuacs_0-1658957905566.png

 

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

Rótulos
Autores com maior número de soluções