combine 2 fields with a delimiter between them

Comments

3 comments

  • Avatar
    Kobbi Gal (Edited )

    You should be able to use the CONCAT function:

     

    CONCAT(toString([account_id]),'_',toString([program_id]))
    0
    Comment actions Permalink
  • Avatar
    Ido Darnell

    I'm pretty sure the issue is with the double quotation marks around your underscore, so instead of the CONCAT function you could simply use a sungle quotation mark as follows:

     

    toString([account_id]) + '_' + toString([program_id])

     

    Let me know if I can further clarify, always here to help :)

    Ido Darnell

    ido.darnell@qbeeq.pl

    www.qbeeq.pl

    QBeeQ Sisense Partner Page 

    0
    Comment actions Permalink
  • Avatar
    Bill Green

    The single quotes '_' work. Even with the Concat function double quotes throw the error. Thanks to both of you for a quick response. I appreciate the help.

    0
    Comment actions Permalink

Please sign in to leave a comment.