Free Trial

Alteryx Designer Desktop Discussions

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

Output data (with different headers) to respective tabs of same excel

hjiang1217
6 - Meteoroid

Hi everyone, I've a workflow with various results look like below, and I'm wondering how'd I output them into different tabs of one same excel file, with each tab has only respective columns, and tab name would also be different (say it could be the 1st column header of each result)  -  I don't think union tool works here (?) as I have different headers, and realistically I've ~20 sets of results so having 20 output tools is not ideal (and will have read/write issue if I try to output 20 tabs together on same file). Thank you for any idea!! 

 

Food SampleFood NamePrice
A1X10
A2Y20
A3Z30

 

 

Furniture SampleFurniture Color
B1Red
B2Blue
B3Black

 

Pet SamplePet BreedPet AgePet Toy Name
C1AAA1AA
C2BBB2BB
C3CCC3CC
2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@hjiang1217 
I guess the data you are trying to output is generated from place to place, so I think maybe we can work this out with combination of providing full path and Block until Done tool as shown in the simple sample below.

0503-hjiang1217.jpg

 

hjiang1217
6 - Meteoroid

@Qiu thank you!!

Labels
Top Solution Authors