Excel Data should be in the form of $$, but out of 25,000 ish records, I find that I have an excel data format error. A large number of values 'in excel' for some odd reason were saved as a date format. In theory I could go open excel, change format to $$, save and move on. The problem is a have a large number of files and more than a single column.
I am combining all these files and I need Alteryx to take anything it finds in these columns that's formatted as a date and shift it to $$.
Thoughts ? Help?
Solved! Go to Solution.
Can you provide an example Excel file with the formatting issue, and what what you expect the result to be? Thank you!
Thanks Joe, but a member of my team actually discovered a solution. We changed the "INPUT TOOL" data format from .xlsx to Excel "Legacy" format and it read in all the data in exactly the format needed.