Concatenation from two different tables - Explanation Needed

Question

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 element or the other. What's up?

Tabel A = ID (formatted as Whole Number)

Table B = Product Category (Formatted as Text)

Because these live in two different tables, it doesn't seem to recognize that I want to concatenate two elements from two different tables?

Thoughts?

ruecj5 · Answer

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.&nbsp;Column&nbsp; = CONCATENATE(Table1[column], RELATED(Table2[column])) worked for me when I tested.

greg_deckler · Answer

I believe that you want to create a Merge or Append query. Kind of sounds like a Merge query is what you are describing.

greg_deckler · Answer

Anonymous&nbsp;- We don't need actual data, just sample data that is representative of your data. Do you really have just a single column in your data tables? Is it at least in the same order for both? If it is, you might be able to add an Index column on import for both and relate them that way via the Index columns.&nbsp;The issue I think that we are all struggling with is that you want to concatenate two values from two separate tables but I do not see anything in any of your posts that shows how these tables are related to one another. That is going to be a requirement for any solution, a way to say that "Apple" is related to "123456". If there is no way to relate these two things programmatically I don't see a solution unless you would manually create a relationship table but at that point, you would already have the solution in manually creating that table.

anonymous · Answer

Greg_Deckler&nbsp;Possibly, though I am not sure how to do this?&nbsp;I am siply trying to create a third column in my data that combines the Product with the ID.&nbsp;Becasue they live in two different tables, the Concatenate function doesn't work (but would if both data elements were in the same table).&nbsp;Recommendations?

greg_deckler · Answer

Can you post a short sample of your data? What I am wondering is if there is a common key between your tables. In the Query Editor, on the Home tab all the way to the right is the "Merge Queries" link. This allows you to merge two queries as you are suggesting as long as you have some kind of common key between them.

Forum Discussion

Concatenation from two different tables - Explanation Needed

8 Replies

Related content

DAX Code Explanation

Table Pivot, result explanation

Fabric Warehouse changes explanation

Concatenate lists ;

Formula Explanation