Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table Visualization - concatenate columns from two tables into one column

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

     

     

    Paul Zheng _ Community Support Team

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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 😞