Forum Discussion
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 from Table 2 to table 1. The final table I am looking for should look like this:
Any ideas how I can get this done?
Thank you.
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.
2 Replies
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.