Forum Discussion
Solved
Concatenate
Hi everyone, Is there a way of joinning 2 columns from different tables, but related? I'd like to concatenate prodCode from Tab Sales with product from Tab Products. Can you help? Thanks in advanc...
If they are related through a one-to-many connection (say table A annd table B), go to the B table and add a new column:
Concatenate = 'B table'[column1] && related(A table[column2])
Since Product contains 1 Value and Sales Contains Multiple Values therefore Reference Column will be created on Many Side because it will return 1 value from product. In this case you should create column in Sales Table rather than in Product Table.
Rule of thumb, reference column will always create on Many Side
If they are related through a one-to-many connection (say table A annd table B), go to the B table and add a new column:
Concatenate = 'B table'[column1] && related(A table[column2])