Alteryx Designer

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

One of my 20 Excel files will not load into Alteryx

Highlighted
5 - Atom

So I am currently uploading 20 Excel files into Alteryx. Only on one of the files I keep receiving the message filename "has a different number of fields than the first file and will be skipped." Could someone provide detailed explanation on how to correct this error? Thankyou

Highlighted
Alteryx Certified Partner

I would take the following steps for the file if causing the error, if you know it, or for all the files.

1. Confirm that column headers in row 1 are identical and have no typos

2. Navigate to the first empty column at the right, highlight several columns and right-click and select delete. It sounds like Alteryx is detecting a value or formatting in one or more cells to the right of the data and defining one or more additional fields.

 

 

Labels