Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Concatenation using variables

I need to have a result column in my report be a concatenation of text and conditionally, 1 or 2 addtional text 'values'.

"Donor+xxxx" - in every row
conditionally, if donor # from table 1 matches a donor # from table 2, I need to concatenate "+yyy"
Further, if the State in another table = a certain value, additional concatenate "+zzz'

Both the yyy & zzz are optional

End results could be any of:
Donor+xxxx
Donor+xxxx+yyy
Donor+xxxx+zzz
Donor+xxxx+yyy+zzz

yyy and zzz are not present in any table, just text values to concatenate.

 

I've been playing with using variables and concatenations and Related, but no success.

2 Replies

  • Arul's avatar
    Arul
    Super User

    Anonymous ,

    Can you share the sample data?

     

    Thanks,

    • Anonymous's avatar
      Anonymous
      Not applicable

      I'm not certain the best way to share data information.  Will the relationship diagram help? 

       

      Here is what I've tried to start - I'm trying to create a measure on a donor transaction table checking to see if the donor number is in the CHG table.

       

      TestReq =
       var CHG = RELATED(CHAGAS[TIDONR])
       RETURN