Render Output as INPUT for the same workflow

If you're going to immediately input the same data, couldn't you just connect your downstream processes (that happen after you re-input the data) to the tool that feeds into your Render tool?

sanketkatoch05

Hi, @jamielaird ,
Can you explain with an example, please.

Thanks.

DawnDuong

hi @sanketkatoch05

You can add another sheet to an excel by using the normal output tool. Is there any reason why you must use a render tool to write to Excel?

Dawn

sanketkatoch05

Hi, @DawnDuong.

Thanks for replying.

The reason why I'm using Render tool is because I'm creating multiple pivot-type tables and putting them onto different sheets of the workbook.

The data that is used to create these tables is the one I want to attach to this workbook as a separate sheet. But this data is huge and cannot simply add it to the same render tool as the previous tables.

Hence, I'm looking for a different approach.

PedrodeOl

@sanketkatoch05 ,

You could try combine Block Until Done + Output Tool to do what you want. Otherwise, if you attach a workflow here we could try to improve it.

sanketkatoch05

Hi @PedrodeOl & @DawnDuong ,

The workflow ran well only for the first time. While I did the second run, the excel ouput file is showing me :

sanketkatoch05

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.

dummy_render.yxzp

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.