Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Merging Tables

I currently have 4 tables that would be considered siblings because they all have container_id & truck_id. The rest of the columns vary among the 4 tables. I attempted to make a relationship between ...
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

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's avatar
    Anonymous
    Not applicable
    10 years ago

    That makes sense but question how will I be able to pull all that data into a single column. This table has 3 million+ rows and thats from one table alone. Is there a way I can formulate the table within Power BI using sql or will it have to be done before importing into power bi from informix?