SALESFORCE IMPORT DROPPING LEADING ZERO

I have a text field in Salesforce I am trying to import that has custom GUIDs that will sometimes have a leading zero. Upon import into Domo however (as far as I can tell), the leading zero is being dropped. Ideas?

Comments

  • RGranada
    RGranada 🟒

    Hi,

    Β 

    Have you checked if the field is still a text field after importing?

    You can insure that domo treats that field as text by using the folowing BeastMode :

    CONCAT('',`Field Name`)

    Β 

    Hope this helps.

  • That will allow me to convert after import, but by then I have already lost the leading zero(s), if present. I'm trying to figure out a way to import w/out loosing any characters. Thanks.

    Β