We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

input data coming from multiple streams want to write it in one single excel sheet

karanjugran
7 - Meteor

Hi folks,

I have data coming from multiple streams and I want to write the data in a single excel file in multiple sheets,

using block tool with the output tool I am unable to do that. Please find the attached WF. I have added formula tool which adds field name SheetName1,SheetName2,SheetName3 and in the output tool configuration I have selected 

Output options : Create New Sheet

Append field map : By Field Name.

Do appreciate for the Inputs in this regards.

 

Karan Jugran

Ask Question on alteryx community.PNG

4 REPLIES 4
Sebastiaandb
12 - Quasar

Hi @karanjugran

 

Can you add the workflow :-)? I bet when u use the full path in the formula tools instead of just the sheet name that it might just work out, if you attach the wf i'll make a dummy for you. 

 

Greetings,

 

Seb

DataNath
16 - Nebula

@karanjugran where you have multiple streams that you can't simply use a Block Until Done tool or change the sheets in the Output Data tool, I'd recommend using the Parallel Block Until Done macro, which is part of the CReW Macros pack - http://www.chaosreignswithin.com/p/macros.html

 

You can chain two of these together in your case to Output Sheet1 before then writing Sheet2 and Sheet3 in sequence.

karanjugran
7 - Meteor

Hi @Sebastiaandb ,

 

Sorry for the late reply and thanx for the mes.

Please find the attached wf, I made some changes but still,  I am unable to write the data.

Error- The process can't access the file because it's used by another process.

 

Thanx for the help in advance,

 

Best regards,

Karan Jugran

grazitti_sapna
17 - Castor

@karanjugran  Can you please try adding union tool after formula tool and then use layout and divide data from all inputs to different sections and render the output to excel as below:

 

grazitti_sapna_0-1662460724712.png

 

Sapna Gupta
Labels