To many fields defined

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,

Preparation

Accepted answers

BenMoss

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+2003+&aqs=chrome.1.69i57j0.8132j0j4&hl=en-GB&sourceid=chrome-mobile&ie=UTF-8

All comments

BenMoss

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

BenMoss

nicho_x86

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,

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703