Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Concatenation from two different tables - Explanation Needed

Using the New Column function, I am attempting to concatenate a column from one table with a column in another table.   Depending on which table I create the column, it either recognizes one data e...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler

 

Wish I could post a sample dataset...I cannot.

 

I am siply trying to combine the the value from one column in Table A with a column in Table B.

 

i.e. 

 

Table A  = Apple

Table B = 123456

 

New column equals "Apple 123456"

Appreciate your interest and advice.

 

Thanks,


Adam

 

ruecj5's avatar
ruecj5
Icon for Advocate I rankAdvocate I
8 years ago

As mentioned by @smoupre you can concatenate vlaues from two separate tables as long as there is an established relationship between the two by nesting the RELATED function inside CONCATENATE.

 

Column  = CONCATENATE(Table1[column], RELATED(Table2[column])) worked for me when I tested.