This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a table tool that outputs number and dates to an excel file. The problem with the date field is that theres no month/year drop down in excel and for the number field the 2 decimals don't show up in the table but only when the cell is selected. How do i reach the deisired output? is this possible?
In my output, the data type for "Value Date" is set to a date and the filters drop down appearing on Excel seem to be working fine
If the data type is set to string, it makes sense for Excel to be unable to pick the different dates correctly because it's looking at the discrete values of dates.
Also, are you using a Table tool from the Reporting tool categories to output that table? I can see in the screenshots you sent attached that some lines have a different background shadings than others.
@porpergrey - Try this method for fixing your date format issue.
The default format for date is "YYYY-MM-DD" in the Alteryx workflow, so in the end of your workflow (but just before the Output tool) you need to convert that date field into desired "mm/dd/yyyy" format then export your data through the Output tool.
Please attach your dummy records for speedy solution.
If you're using a Table and a Render tool, I don't think you can do much about it based on what I am aware of.
The table converts into everything into plain text, so you lose the property of date. Hence, Excel can not subsequently understand that the information contain in that field is a date and return you the desired dropdown in filters.
@AngelosPachis okay, thanks got it now. What about the numbers.. I see two decimals missing in the table but once the cell is selected it shows us in results in excel. How do I make it in the cell itself? using a table tool here