Forum Discussion
concatenate values
I need to unite the values of fields of type text in two different tables, how can I do?
Hi Anonymous,
You can nested CONCATENATE() within CONCATENATE() to add concatenate more characters you need.
CONCATENATE(string_expression,CONCATENATE(string_expression,string_expression))
Regards,
8 Replies
- MattAllington
Community Champion
Well it depends. Are the tables related? Are you writing a measure or a calc column? Why do you want to do this - IE what are you trying to achieve and why?
- MattAllington
Ok, you assuming you are writing a measure over your data table, you can use the RELATED() function to do what you want. https://msdn.microsoft.com/en-us/library/ee634202.aspx
If you are writing a measure over a lookup table, there is a RELATEDTABLE function, but this may be an issue as it will return multiple rows of data.
- qwertzuiop
Advocate III
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
