Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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