Output more than one table into same excel with different tab

HI All,

I have a various report designed in Alteryx and would like to combine all reports and output as one excel but with different tab.

I am able to use Union Tools and then Render tools + select section breaks between records, however i find that I can't name the tab (they are named as sheet 1 sheet 2 sheet 3 etc) and sequence of tab is not set according to the union sequence 1,2,3.

Is that a way I can set the sequence of the tab and rename the tab? I also tried to use output tool but seems i am not able to combine three table into one output?

Also attach the desire output for quick reference. Thanks!

timetable workflow.yxmd

Timetable - desire output.xlsx

Monday.xlsx

Tuesday.xlsx

Wed.xlsx

Output

Accepted answers

messi007

@newlearner123,

You are already doing it, Or I misunderstand something.

You want every sheet with the 3 tables together or one table per sheet.

Please see below the union part

Regards,

All comments

mhey01

Hey @newlearner123

You can do this with the 'Block Until Done' tool. Click the search bar in the top right corner of Altreyx Designer and type 'Block'.

Block Until Done has three outgoing ports labelled 1, 2 and 3 (1 is executed first, 2 second etc). You can then choose what data goes to which Excel Sheet using 3 separate Output tools.

Give that a try 🙂

messi007

@newlearner123,

Not sure if you can rename the sheet name.

Below how you can generate multiple sheets

Attached the workflow,

Hope this helps!

Regards,

timetable workflow.yxmd

newlearner123

Thanks Mhey01,

I am very new to Alteryx, do you mind modified the workflow for me for quick reference?

As there is only 3 labels in Block until done tools, if I have more than 3 tabs would like to create, what should I do?

Thanks in advance

smoskowitz

Hi @newlearner123 --

Yes, you can name the tabs, but its not straightforward.

Before your basic table tools add in a formula tool and create a column called Sheetnames. In the fomula, just create a sheetname -- so "Monday". Do this for each table.

In the Basic Table on the bottom where it says For Column Headings -- uncheck Sheetnames..

Add in a layout tool after your report text. Configure as below.

Let me know if this works for you. I currently use this in some of my workflows.

Thanks,

Seth

messi007

@newlearner123,

thanks to @smoskowitz I learned new thing today.

below the updated workflow

Hope this helps!

Regards

timetable workflow.yxmd

newlearner123

HI messi007
Thanks for your workflow. May I know the tool "Vertical layout section break" is literally referring to how I organisate the workflow vertically like the yellow arrow?

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235