community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Combining the Rendered Table report with other Excel sheets

Meteoroid

Hi everyone,

 

I have searched the community inside out for this answer, but I am not finding anything. Please help!

 

I am trying to output my Table report and the original dataset to the same excel file, but on different tabs, using Render and Output tool. Please see below for a picture of my current workflow. 

Help.PNG

Ideally, I want to output the Table and original data in the same file, but every time I do this, the file outputs only the table and outputs the "Above 50k" tab but it is a blank sheet.

 

FYI, I have a "Block Until Done" tool set up  - just not pictured in the screenshot - so the table is outputted first and then the original data tab. So this is not an issue of timing. Also to clarify, I wish to get this job done in one workflow, rather than create another workflow to input two different excel files and output to a combined file, because I have multiple tabs and files to run this workflow on. It would be an annoyance to run two workflows every time. 

 

Is it impossible to combine these two reports in one excel file with one workflow? Thanks in advance! 

Asteroid

If you are only wanting a table of data just on a separate tab then would it not work to not use the table tool but rather output to a specified tab in excel?

 

If the workflow is causing a problem where it is trying to write to the same file then you can use the Block Until done or Parallel block until done tools where it will process one stream and then the other and as such is writing to the same file at different times.

 

I am not sure if that will help you achieve what you are looking to achieve?

Nebula
Nebula

Hi @euginalim 

 

Check out the technique used in the solution to this post.  The very clever @DavidP has solved this problem by moving the block until done to just before the report preparation.  One of the key things he mentions is that the render tool actually creates both sheets, but puts only dummy data in the one that gets over written by the output tool.

 

Dan

Meteoroid

Thank you! This was the solution I was looking for!!

Meteoroid

@danilangIt worked perfectly! Thank you for relaying @DavidP's solution!

Labels