Merging the two large datasets using joins/unique key

Reply
Occasional Contributor
Posts: 5

Merging the two large datasets using joins/unique key

Hi ,

I’ve two big datasets and both don’t have a unique_id to join/merge, Does any one have an idea how to join them? Data_1 is a summary file and Data_2 is a detail of the summary of the file. Here is an example of both datasets. Any help is appreciated?

Data_1 is a summary file

IDGroup
00233ABCD
00233ABCD
02013Oxy
02013Oxy
02013Oxy

Data_2 is a detail of the summary of the file

IGroup
0233ABCD
0233ABCD
0233ABCD
0233ABCD
0233ABCD
0233ABCD
0233ABCD
PSM2013Oxy Inc
PSM2013Oxy Inc
PSM2013Oxy Inc
PSM2013Oxy Inc
PSM2013Oxy Inc
Super User
Posts: 5,257

Re: Merging the two large datasets using joins/unique key

Again, you need to describe what kind of output you wish - especially when you don't have unique keys.

Data never sleeps
Super Contributor
Posts: 644

Re: Merging the two large datasets using joins/unique key

This question has already been discussed in the last few days.  Please view.

Richard in NZ

Ask a Question
Discussion stats
  • 2 replies
  • 155 views
  • 0 likes
  • 3 in conversation