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

cathynewton
cathynewton βšͺ️

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

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟀

    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
    jaeW_at_Onyx Budapest / Portland, OR 🟀

    @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.