Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

XLS output creating apostrophes at the beginning of string columns

gdefazio
5 - Atom

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

1 REPLY 1
alexnajm
18 - Pollux
18 - Pollux

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

Labels
Top Solution Authors