Data Resolution

[Polite123]

Hello guys,

Please suggest me for the below issue

I have an Excel file named DataSet which has 5 different sheets.

I want to add an extra 6th sheet in that excel file generated through Render tool.

I am unable to add it with other five and also unable to rename the 6th sheet.

Thanks in advance:)

[Emil_Kos]

Hi @Polite123,

Please check this link:

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

I think you should find a solution here. 

[mceleavey]

Hi @Polite123 ,

You need to use a formula to create the output filepath which addsd "|||<Sheet name>" to the end of the filename. This will allow you to output to the named sheet and create a new tab within it.

M.

[Polite123]

Thanks a lot @Emil_Kos and @mceleavey. 

I am now able to add sheet name but unable to merge them with other sheets of the same file.

Please suggest.

[atcodedog05]

Hi @Polite123 

Render tool supports only replace functionality it doesnt support append functionality.

A workaround would be read the previous files sheets and use union to add new data and write it through render. By this you would have merged old and new data of a sheet.

Hope this helps 🙂

[Polite123]

It didn't work @atcodedog05 😞

[atcodedog05]

@Polite123 

Hmm... thats bad

But yes render tool works only on replace data not append data.

I will let you know if i find anything or any workaround.