Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have 2 data sets 1 is A and another one is B
A: 1,2,3, upto 10 millions record
B:1,2,3, ......10 millions of record.
I need to get the associated records from the both the data sets in to one resultant set.
Output:
A B
5 5
10 10
20 20
upto 10mils records
Regards,
Sunitha
I need to get the associated records from the both the data sets in to one resultant set.
What do you mean by above, can you explain bit more on this ?
I want to show the Same records from both the 2 data sets There are no common fields but need to associate with common records
There are multiple ways to get it done like you may use Inner Join by renaming the field and having a condition basis the same, or probably use Exists Keyword, it depends on the kind of data you are dealing with , providing a sample input and desired output , will help to find what exactly you are looking for
Hi Anushree,
Kindly let us know all the ways to get the result.