Hi all,
I am converting a cvs file to an xls within my workflow, and it is returning columns with ' before strings only. When I attempt to run the file back through Alteryx, it does not show the apostrophes before the strings and only shows when I open the excel file. The output looks normal when in a regular xlsx file.
Example:
xlsx output: 4R47223
xls output: '4R47223
I'd recommend outputting to .xlsx - .xls is a legacy file type that will no longer be supported going forward! Whatever system needs it as .xls, I would push back and see if you can do .xlsx
User | Count |
---|---|
109 | |
92 | |
78 | |
54 | |
40 |