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

[oneillp111]

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?

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

[aguisande]

hi @oneillp111 

Can you attach a sample of your workflow + data to see what may be happening?

[oneillp111]

I have attached a small sample set.  The output Overall_Bin_Report is what I need the data to look like, however all the data has become Numbers.

[aguisande]

Hi @oneillp111 

I went over all possibilities on your workflow, and couldn't get a date type field in the generated report vía Render tool.

This may be a case to contact support@alteryx.com and see if this is a "by design" feature.

[oneillp111]

@aguisande ,

Thanks for the help. I will check with them

[ntobon]

You are running into a known defect: 

DE21616 - Render tool to Excel will be in number format regardless of the data type.

It only appears to be a problem when using the Render tool to create Excel files, even in the Gallery. The Output Data tool appears sets the fields appropriately.

As a workaround, you can manually change the format of the column or cells in the Excel directly.

[oneillp111]

@ntobon ,

Thanks for the info, That would not be an issue for me except that I email the report from Alteryx to various people and having to change formats is not ideal for a final report.

[aguisande]

Thanks for the fast reply.