Alteryx filter output to multiple excel tabs in one excel workbook

Hi There,

I'm badly stuck in a situation where i'm trying to output filter results to multiple tabs in an excel workbook, which i name dynamically using the Output tool configuration. So, i use the first filter results to create an excel output and use block until done tool for to output further filter results. Below is a snapshot of my workflow and the error i receive( i have tried changing the output options to Overwrite File, Create new sheet, Drop file) but nothing seems to give me what i'm looking for.

Workflow

output to multiple excel tabs in 1 workrbook.PNG

Also, my company doesn't allow me to install crew macros package so can't use Parallel block until done.

Please help as i have spent days figuring out what do i do

TIA.

Workflow

Developer Tools

Tips and Tricks

Accepted answers

Aidan_K

Hi @Bhavika

I am attaching my sample workflow for your review.

Here you can see the same results created with the block in both (different) places which should help accommodate your results.

I hope this helps

Regards,

Aidan

Wkflow-@Bhavika.yxmd

All comments

Aidan_K

Hi @Bhavika

Try changing your first filter ([Balance_USD]!=0 to come from your first block until done (No. 1) instead of straight from the select tool.

this should fix the writing priority issue

if you attach the workflow (or part of it) I can update for you too if you like

Rgds,
Aidan

JordanB

Hi @Bhavika

What version of Alteryx are you on? (Help>About)

Looking at your workflow I would build you stream off the first block until done tool. Your top workflow needs to come out of '1'. The second stream comes out of '2'

I used this workflow for a reference: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Bug-Multiple-Output-Data-to-Excel-Overwrite-Sheet-mode-Error/td-p/74042

Best,

Jordan

Bhavika

@Aidan_K Due to IT permissions, i cam't attach my workflow or related files here. So, posting the snapshots.

@JordanB I'm using Alteryx Admin Designer 2018.3.4.51585.

As suggested, I have made the changes. However, still face the same issue.

I'm also attaching a snapshot of my 1st output tool configuration. For the 2nd, the only change i made was 'Overwrite sheet(Drop).This creates the output out of 1st output tool. But, 2nd output tool errors out.

The 'TabName' column referred in the Output tool configuration has the below formula:

"H:\Alteryx\Control Check Automation\C3 Check\Output\C3_Codeblock_mapping_check_BD1_" + left(datetimeformat([COB_DATE],"%B"),3)+ "_new.xlsx|||" + "Unassigned with balances"

For the 2nd output tool, the 'TabName' column has just the sheet name changed:

"H:\Alteryx\Control Check Automation\C3 Check\Output\C3_Codeblock_mapping_check_BD1_" + left(datetimeformat([COB_DATE],"%B"),3)+ "_new.xlsx|||" +"Peaks Data with SAP AC"

Block until done updated.PNG Output tool configuration.PNG

Also, i did refer to this suggested post but couldn't find a solution there.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703