Table Visualization - concatenate columns from two tables into one column

[Anonymous]

Hello,

I have two tables where each one has a column called 'name'. Is there a solution where i can concatenate those two columns into a single one in a table visualization without creating a new table? Otherwise it won't work relationshipwise because of another table which is needed for a network navigator graph.

Example:

Table 1:

name

Daniel

Georg

Table2:

name

Thomas

Ana

Output - Table Visualization:

name

Daniel

Georg

Thomas

Ana

Thanks in advance! 🙂

[Anonymous · Accepted solution]

@Anonymous 
What about append the table2 to table1 in power query.

Paul Zheng _ Community Support Team

[amitchandak]

@Anonymous , You need to create a new table of names

distinct(union(distinct(Table1[Name]), distinct(Table2[Name])))

Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19

[Anonymous]

Thanks for the quick response!

The Problem ist that with a Bridge Table it will always lead to a relationship which isn't active.

Below you can see the Tables and the relationships. The column 'source_node' in table relationships_colored contains the names of the column 'name' in the table Source (relationships_colored[target_node] = target[name]). If I create a Bridge Table and connect it afterwards to the tables 'target' and 'source' I'm not able to cross-filter my dashboard.

Could be that i understand something wrong 😞