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

Alteryx designer Discussions

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

To many fields defined

Highlighted
Asteroid

Hi There,

 

I keep receiving this below error in my workflow. The file currently has 247 columns and I am adding another 125 although have only attempted 20 so far and receiving the below warning. Is there a limit to the number of columns in Alteryx?

 

Error: Output Data (3): Error creating table "Sheet1": Microsoft JET Database Engine: Too many fields defined.\3190 = -68092944

 

Thanks,

 

Alteryx Certified Partner
Alteryx Certified Partner
This looks like a problem with the file type you are trying to write, which judging by the error is an .xls file.

Try outputting as a .xlsx if possible, there used to be a much smaller restriction on older excel files than on existing ones.

Ben
Alteryx Certified Partner
Alteryx Certified Partner
A quick google seems to confirm this, .xls files only support 256 columns https://www.google.co.uk/search?q=excel+column+limit+2003&rlz=1CDGOYI_enGB747GB747&oq=column+limit+2...
Asteroid

Thanks, that would make sense as I have more columns. I am still getting the same error when I change to .xlsx

Asteroid

Ignore that my bad it does work!  Thank you very much!

Meteoroid

I'm experiencing this same problem and I can't work out why.

 

I am using a module with an xls input. When I run it on mine it works fine. When I run it on my colleagues machine she gets the error.

 

Any idea what it is that causes it to work on one machine and not the other?

 

Thanks,

Labels