Forum Discussion

dennis1994's avatar
dennis1994
Frequent Visitor
8 years ago
Solved

Combine two tables

Hello, I would like to combine table 1 and table 2 from my photo, so that i end up like table 3. i dont quit get it. Can someone help me please?   Regards Dennis
Need Help
Tips and Tricks
  • Rfranca's avatar
    Rfranca
    8 years ago

    hi, dennis1994 acanepa

     

    1. Import the data from TABLE1
    2. Import the data from TABLE2
    3. Edit the query in TABLE2 and remove the duplicates
    4. Combine tables TABLE1 and TABLE2
    5. Group the values (as pictured)

     

     

     

     


    Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
     
    Best Regards,
    Rfranca

dennis1994's avatar
dennis1994
Frequent Visitor
8 years ago

Hello acanepa,

 Thanks for the fast reply. Where exactly do i need to input the code? When i try to create a new table i get following error:

 

acanepa's avatar
acanepa
Resolver I
8 years ago

Hi dennis1994

 

You need to change the column name "dri_exact_date" in one of the tables, the formula does not allow two columns with the same name.

 

You could use SELECTCOLUMNS for filtering columns.

 

Regards,

  • Rfranca's avatar
    Rfranca
    Resolver IV
    8 years ago

    hi, dennis1994 acanepa

     

    1. Import the data from TABLE1
    2. Import the data from TABLE2
    3. Edit the query in TABLE2 and remove the duplicates
    4. Combine tables TABLE1 and TABLE2
    5. Group the values (as pictured)

     

     

     

     


    Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
     
    Best Regards,
    Rfranca