Alteryx Designer Discussions

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

Output data using Table and Render changes all data to Number format.

oneillp111
8 - Asteroid

I am using Table and Render to create a report with formatting so it has a better look to it.  The issue is that when the report comes out, all the data is formatted as numbers, including the dates.  When the file is opened in Excel, sorting and filtering useless because all the formatting is Number.  If I use the Output tool, the data stays in the correct format but the look is not as appealing.  Does anyone know of a way to correct this issue?

 

RENDER.png

 

The output tool is the format I need and I cannot figure out how to get this via the Render tool.  Any ideas are appreciated

16 REPLIES 16
Jo-B
7 - Meteor

It would be great to get updates on this issue! 

ntobon
Alteryx
Alteryx

@Jo-B DE21616 is still open. We do not have an ETA on when a fix will be out. 

okakosolikos
6 - Meteoroid

I just ran on this issue, any updates?

oneillp111
8 - Asteroid

@okakosolikos there is still no fix. I did a workaround with a small python script.  It seems work great.  

 

I use openlyxl and xlwings module to format the report.

okakosolikos
6 - Meteoroid

Sounds really interesting but definitely a no-go if you're working in a big corporate...

aaronlong
5 - Atom

@ntobon 

Are there are any updates or ETA on this?

ntobon
Alteryx
Alteryx

@aaronlong DE21616 was fixed in version 2021.2

Labels