SALESFORCE IMPORT DROPPING LEADING ZERO

byusteve
byusteve Member
in Archive

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 Contributor

    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.

    Ricardo Granada 

    MajorDomo@Lusiaves

    **If the post solves your problem, mark it by clicking on "Accept as Solution"
    **You can say "Thank you" by clicking the thumbs up in the post that helped you.
  • byusteve
    byusteve Member

    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.

     

Categories