What is the maximum number of columns allowed in a dataset ?

cathynewton · 2021-03-12T15:16:55+00:00

There was an error rendering this rich post.

Hi,

I am trying to upload some survey data via excel into Domo, I am exceeding the allowed limit and need to understand how I can get around this.

Can I split the data and rejoin in ETL or will I face the same problem when I attempt to join ?

Thanks,

Cathy

Find more posts tagged with

Accepted answers

All comments

MarkSnodgrass

Yes, you can split your data and rejoin the data in Magic ETL. You might also want to look make use of the select columns tile while you are in the ETL and remove columns that you don't think will be used, or branch columns off into separate datasets. Keep in mind, if you want to use a table card, that card type is limited to 100 columns.

jaeW_at_Onyx

@cathynewton there is a default limit; however, if you contact support they can help you / lift the limit.

That said, in my experience, you never need more than a hundred columns unless your data is structured poorly. If you data is structured poorly, then it probably makes sense to restructure it before you pull it into Domo.