Converting data from categories to values

I am uploading datasets from Excel and Domo is pulling specific rows as categories when it should be values. This is making it impossible to create cards with the data. How to a massage the data and put the appropriate fields as values?

Comments

  • I think Domo is reading your numeric fields as String. Unfortunately, if you're uploading an excel file directly into Domo (without using Workbench) you can't control the field types.

     

    I recommend using Workbench to upload data into Domo as it gives you lot more control over your data (you can set the data type for each field) and it's more robust.

     

  • Another alternative to the statement above is to use the ETL Magic Flow. I think the workbench would be a quicker solution still.

  • @Dhoeppner, did any of the replies above help answer your question?

  • It may be prudent to double check the data in your Excel file. I had a similar issue once, and it turned out that due to a copy/paste error a couple of rows had text rather than numbers.