Merging but getting duplicates

Question

I have about 7 queries but I am only trying to get two to work currently.The first data set is&nbsp;KEY&nbsp; &nbsp; &nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date137577&nbsp; 10/10/2023298745&nbsp; &nbsp;10/8/2023387548&nbsp; 10/6/2023387548&nbsp; 10/7/2023387548&nbsp; 10/4/2023&nbsp;The second data set is&nbsp;KEY&nbsp; &nbsp; ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Start of Activity137577&nbsp; 7:00:00 AM298745&nbsp; 11:00:00 AM387548&nbsp; 3:00:00 PM387548&nbsp; 3:30:00 PM387548&nbsp; 6:00:00 PM&nbsp;When I combined them I get a duplicate of the times and ID's I only want a row to show like thisKEY&nbsp; &nbsp; ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Start of Activity1&nbsp; &nbsp; &nbsp; &nbsp; 37577&nbsp; &nbsp; 10/10/2023&nbsp; &nbsp; 7:00:00 AM&nbsp;I hope that makes sense, thank you for any help.

parry2k · Answer

ipon70&nbsp;The first 2 are easy, how do you want to deal with the 3rd one?
&nbsp;

ipon70 · Answer

I just figured once I had a solution I could just repeat the process and include the rest.&nbsp; But if there is an easier way, I am all about learning.

ipon70 · Answer

I just figured once I had a solution I could just repeat the process and include the rest.&nbsp; But if there is an easier way, I am all about learning.

Forum Discussion

Merging but getting duplicates

3 Replies

Related content

Merge queries causing duplicate records

Merge duplicates data in columns

Merge statement creates duplicates - Low shuffle merge as cause?

Table Merge creates duplicate records

REMOVING DUPLICATES AND MERGING QUERIES

1	37577	10/10/2023
2	98745	10/8/2023
3	87548	10/6/2023
3	87548	10/7/2023
3	87548	10/4/2023

1	37577	7:00:00 AM
2	98745	11:00:00 AM
3	87548	3:00:00 PM
3	87548	3:30:00 PM
3	87548	6:00:00 PM