Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to compare 2 tables and merge corresponding data based on one column

Hi All,    I have the following 2 tables from 2 different sources:   I need to compare the release_id column on table 1 to ReleaseTitle on Table 2 to insert the corresponding value fr...
Need Help
Show and Tell
Tips and Tricks
  • Wheezy98's avatar
    Wheezy98
    2 years ago

    Hi Anonymous !

     

    What you need is to merge the two tables, for this, you have to click Merge Queries,

    then you have to select the column of the id in both tables and click ok,

    You will have your table like this:

    So you need to click and expand the column, and then select the column that you need to bring from the second table, in this case, the Timestamp.

    I hope you can solve your problem with these steps.

Wheezy98's avatar
Wheezy98
New Member
2 years ago

Hi Anonymous !

 

What you need is to merge the two tables, for this, you have to click Merge Queries,

then you have to select the column of the id in both tables and click ok,

You will have your table like this:

So you need to click and expand the column, and then select the column that you need to bring from the second table, in this case, the Timestamp.

I hope you can solve your problem with these steps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks very much. I was doing it wrong all along by merging but selecting all columns. Works now!!