community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Help with messy source excel file

Asteroid

Hi,

 

I have exported data from an online CRM to excel. The file downloads as a .xls file, but when I try to connect to it in Alteryx I get the below message.

 

I can connect to other .xls files without issues so I assume there is something else wrong with the file besides the .xls format (I also can't open it using Tableau or Microsoft Power Query).

 

I have tried opening the file in Excel, then saving it as a .csv. The problem with this is that one of the fields has many (but not all) entries starting with zero and these leading zeros are not retained when I save it as a .csv file

 

Does anyone have any suggestions? I need the file in a format that Alteryx can connect to with the leading zeros retained

 

Alteryx_xls file error.JPG

Alteryx Certified Partner

Try saving it as an XLSX.

Highlighted
Asteroid

I worked out that the leading zeros are only dropped when the csv file is opened in Excel. I can open the .csv file in Notepad or Alteryx and the leading zeros are retained

Labels