Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

concatenate values

I need to unite the values of fields of type text in two different tables, how can I do?
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Hi Anonymous,

     

    You can nested CONCATENATE() within CONCATENATE() to add concatenate more characters you need.

     

    CONCATENATE(string_expression,CONCATENATE(string_expression,string_expression))

     

    Regards,

qwertzuiop's avatar
qwertzuiop
Advocate III
6 years ago

Hello there,

 

To connect my divisions, I use this. I wanted to share them with you.

Relation = [startLocation] & " ->" & [targetLocation)]
 
In addition, any string can be selected as the connection: Here ->
 
Cheers qwertzuiop