Forum Discussion
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 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! 🙂
3 Replies
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
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 😞
