Forum Discussion
How to concatenate values from different tables?
I need to set up a field that will have values of 4 different fields and each field is of a different size that relate through a fact table, I tried to use concatenate expression or relate fields through "&" and it did not work, what can I do?
If all of the tables are linked by the same fact table, you can use the RELATED function https://msdn.microsoft.com/en-us/library/ee634226.aspx or you can link the fields with LOOKUPVALUE, but for this you must have a common info between all the tables
3 Replies
vitinhoHelper I
Can you show a print of what you tried to do?
- vitinho
If all of the tables are linked by the same fact table, you can use the RELATED function https://msdn.microsoft.com/en-us/library/ee634226.aspx or you can link the fields with LOOKUPVALUE, but for this you must have a common info between all the tables