Alteryx Designer Desktop Discussions

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

Output date in MM/DD/YYYY format to excel file using table tool and render tool

Ranjith_udaykumar
7 - Meteor

Hi,

 

When I output a date filed using table tool and render tool to excel file, the date format changes to "Number" and  date  displays as 'YYYY-MM-DD' and excel filter does not show the dates grouped by year, month date. 

 

Ranjith_udaykumar_0-1658836650472.png

Instead the filter shows as below  (changes to text filter).

 

Ranjith_udaykumar_1-1658836757909.png

 

If we output the data using output tool to excel file, data comes as expected. Is there is a way to fix this in table and render tools?

3 REPLIES 3
Kakuffo
Alteryx
Alteryx

Hey

 

Is there a particular reason for the table tool to be used to create the output? Could the same output be achieved with the standard out puttool, seems to be alimitation of the table tool. 

 

Otherwise it may be worth utilising a VBS file using script.exe to add the filter function in after it has been exported. all depends on how comfortable you are with working with scripts.

Ranjith_udaykumar
7 - Meteor

The output tool does not produce excel reports with formatted text like heading, conditional formatting. 

riyadh_jose
6 - Meteoroid

Sharing the solution I found.

 

It's a limitation of Excel to read Alteryx Date data as actual date when rendering. 

Solution: Select Data or Column of Data>Go to Data Tab>Select Text to Columns>Select Delimited and then click Finish.

Unable to get Excel to recognise date in column - Super User

Labels