Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Concatenate strings in Mapper snap

I want to utilize the functionality of mapper snap to prefix my value with a static string, then concatenate with other variables and again concatenate with a static string.

I’m able to do the concatenation part however I cannot prefix the string. Any suggestions please?
Thanking you in advance for your time.

pipeline
  • bojanvelevski's avatar
    bojanvelevski
    4 years ago

    If your column is of number type than yes, it won’t work. You’ll have to try something like this:

    "00"+$ID.toString()+"00"

4 Replies

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      4 years ago

      I tried the above approach and somehow it didn’t work for me. I will try a second time and keep you posted…

      • bojanvelevski's avatar
        bojanvelevski
        Valued Contributor
        4 years ago

        If your column is of number type than yes, it won’t work. You’ll have to try something like this:

        "00"+$ID.toString()+"00"