Render Output as INPUT for the same workflow

[sanketkatoch05]

Hi, 

I am building a workflow wherein I need the output from Render Tool as an input.

My desired output file(.xlsx) should have 4 worksheets. The Render tool gives me 3 of those. 

I want to add one more sheet to it but without creating a table since it is a huge dataset and the Render tool is not able to handle it. 

How should I move forward with it? 

[PedrodeOl]

@sanketkatoch05 

If you’re not appending data, only create new one, try to overwrite the excel sheet/file instead of create a new one.

[sanketkatoch05]

The output from the Render tool has 3 sheets in it, I want to keep those sheets and create a new sheet wherein the raw data goes into the sheet. How will I be able to do an "Overwrite Sheet" when there no new sheet created for this data. I don't want to add anything to the sheets that are created by the Render tool. 
I wish I could add the wf here, but that wf is in my VM and I cannot share it in public. Apologies for that.

[sanketkatoch05]

If I do "Overwrite Sheet", I'm given the same error.

But if I do "Overwrite File", all the three sheets created by the Render tool get removed and I'm only left with the dataset sheet.

[PedrodeOl]

@sanketkatoch05 

I've made a dummy workflow which may help you out. I use block until done + render tool to generate the four sheets, 3 with some aggregations and the last one with the raw data. Each run will update the raw field called value.

Let me know if it helps you.

[sanketkatoch05]

Hi, @PedrodeOl. 

Thanks for replying, but the problem here is that my raw data is huge(60 columns and 18k rows) and the render is not able to handle it even after changing the paper size to custom.

[PedrodeOl]

@sanketkatoch05 

In that case, the only solution I've got is:

Use the approach which I did before, instead of write the raw data using render tool, use the output tool creating new sheet, however, you must use the .xls extension to be able to use both render and output in the same file. Using the xls extension will name the sheets acordding their record position.

(table1/record1 = Sheet 1, table2/record2 = Sheet 2 ...)

[DawnDuong · Accepted solution]

hi @sanketkatoch05 

Actually the same has been solved 2 years ago. Credits go to @DavidP 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-Render-and-output-file-tool-to-s...

Cheers,

Dawn.

[sanketkatoch05]

Thanks @DawnDuong , the solution in that thread is exactly how I figured out mine. 🙂

[DawnDuong]

Glad to know it works for you and thanks for accepting this as a solution @sanketkatoch05 (although the thinking credits go to the original post)

dawn