Forum Discussion
Merging Tables
Anonymous
I think you can duplicate the four tables in Query Editor and only keep truck_id column for these duplicate tables. Then append these four duplicate tables and remove duplicate rows. Now you will have a table with only one column with unique truck_id. We should be able to create the relationship like below.
If you want the truck_id and container_id to be the key, you can combine truck_id and container_id into a single column as Vvelarde said.
Best Regards,
Herbert
Anonymous Instead of merging these tables together, couldn't you instead establish relationships between the tables? If your goal is to make visuals that use data from multiple tables, establishing relationships is the best way to go about it. Power BI isn't supposed to be used for merging tables that have an exorbintant amount of rows.
EDIT: What problem are you encountering when trying to establish the relationship(s)? Is it saying the related column isn't specific enough or something?
Yes it says that one of the columns doesn't have a unique value. Which I understand to be because they are all sibling tables with no parent.
You can create a Unique Identifier (Union of Container ID & Truck_ID) in each table and relationship all the tables.
