Need help in saving output in Excel

[mohit9garg]

Hi, I need help in saving workflow output in Excel.

I need to save 3 outputs from a workflow-

Output #1 - Since I need to do some formatting like cell colors, Bold text..etc so I used Table & Render tool. And saving this output in excel. 

Output #2- There is an another output which I need to save in Output #1 file but in a different tab.

Output #3- I need to re-save the Output #2 in .txt format.

Please assist me.

Thanks,

Mohit

[Emil_Kos]

Hi,

for the output 2 Please use the block until done tool.

I think this article might help you.

https://help.alteryx.com/current/designer/block-until-done-tool

for the output 3 please refer to the article below:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/output-TXT/td-p/820

hope it helped.

[mohit9garg]

Hi- Refer below snapshot of my workflow. There is no issues with .txt output, its working now (Output #4)

However I need Output #1, 2 & 3 in same excel but with different tab names. How Can I do that-

[Emil_Kos]

Please check the article below:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Block-Until-Done-cant-figure-out-how-t...

block until done is the tool that you want to use in a circumstances like this.

[mohit9garg]

I am already using 2 'Block Until Done' tool. How can I specify tab names in RENDER tool and save 3 different outputs in same file-

@grossal

@DavidP 

[Emil_Kos · Accepted solution]

Apologies. My bad I didn’t looked into your workflow properly. 

please check the layout tool. According to the article below it should help you.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-the-Render-Tool-under-Reporting-...

[mohit9garg]

Thanks this worked !!!