Merging the two large datasets using joins/unique key

[nagu]

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

ID	Group
00233	ABCD
00233	ABCD
02013	Oxy
02013	Oxy
02013	Oxy

Data_2 is a detail of the summary of the file

I	Group
0233	ABCD
0233	ABCD
0233	ABCD
0233	ABCD
0233	ABCD
0233	ABCD
0233	ABCD
PSM2013	Oxy Inc
PSM2013	Oxy Inc
PSM2013	Oxy Inc
PSM2013	Oxy Inc
PSM2013	Oxy Inc

[LinusH]

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

[RichardinOz]

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

Richard in NZ