Data Type for File Import

calvert_schaefer · 2025-07-08T11:49:50+00:00

There was an error rendering this rich post.

I'm having an issue with a file import data source in Domo. In my excel file, I have leading zeros and the data is stored as text, however when I import the file into Domo, it drops the leading zero and converts to a number.

Is there a way to set the data type on import as text so this issue doesn't happen ? I know I can just create an ETL to another table and use LPAD() to add my leading zero back I just want to avoid adding another table if possible.

Excel format

Data in Domo

Find more posts tagged with

Data Sources

Accepted answers

All comments

MichelleH

@calvert_schaefer There is an option in the file upload connector that you can check to keep leading zeros like this:

calvert_schaefer

@MichelleH Apologies, I should have included the exact data source icon. I'm using the newer file upload connector

ArborRose

@calvert_schaefer - I see what you are saying. There is no option for keeping the leading zeros when you use that connector. I think you need to submit to Domo Support. Is there a reason for using that connector rather than just upload a spreadsheet under the data center?

ColemenWilson

The current, Domo recommended, file upload connector has the option to keep leading zeros. I would recommend following their recommendation and use this one by clicking "CONNECT DATA" and then "FILE" when adding new data.

MichelleH

@calvert_schaefer It looks like the leading zero check box isn't available for that connector, but it is for the default uploader on the File tab if you're able to use that instead.

Otherwise, if your Store ID field is always 4 characters you can create a beast mode to add the leading zero back like this:

case when LENGTH(STORE_ID) = 3 then CONCAT('0',STORE_ID) else STORE_ID end