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 If the tables all have different columns but share container_id and truck-id you would want to merge instead of append. What other data do the tables contain? Can you provide a snapshot of the tables?
As an alternative, you could create a lookup table with container and truck id to make relationships possible. See this blog for how:
Here is sample of the tables. I am attempting a full outer join megre on two of the tables with container id selected on both, and its going slow. This table has about 9 million rows and when it hits like 160k it just stops on the full outer join.
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.
