We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Render tool usage

Aakanksha_chandak
8 - Asteroid

I am getting this error (enclosed screenshot) while using render tool to preserve format of the xlsx file, how can I sort it?

6 REPLIES 6
binuacs
21 - Polaris

@Aakanksha_chandak Connect your select tool output to a table tool then connect to the render tool

Aakanksha_chandak
8 - Asteroid

Attaching the table below. I want my values to get filled accordingly within the cells of the table and output should have exact format of the table as inputted. 

Raj
16 - Nebula

@Aakanksha_chandak 
why don't you use blob tools to preserve the format and using output tool you can write in specific cells?
this will preserve the format of the sheet as well as the formula you have added for further calculations if any.

Aakanksha_chandak
8 - Asteroid

Can you please help me with a sample workflow? I am unable to figure it out.

binuacs
21 - Polaris

The below post has the information about the blob tools also you can find a sample workflow 

 

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...

Aakanksha_chandak
8 - Asteroid

still cant figure it out

 

Labels
Top Solution Authors