Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to join 2 tables into one:
Table 1:
Reference | Region | Regulator |
100 | US | DODDFrank |
101 | EMEA | EMIR |
102 | US | DODDFrank |
103 | US | DODDFrank |
104 | EMEA | EMIR |
105 | EMEA | EMIR |
106 | EMEA | EMIR |
Table 2:
Static_region | Static_Regulator |
US | DODDFrank |
EMEA | EMIR |
in the following manner: Static Region(T2) = Region (T1) and Static Regulator(T2) is equivalent to Static Region(T2):
Reference | Region | Regulator | Static_Region | Static_Regulator |
100 | US | DODDFrank | US | DODDFrank |
101 | EMEA | EMIR | EMEA | EMIR |
102 | US | DODDFrank | US | DODDFrank |
103 | US | DODDFrank | US | DODDFrank |
104 | EMEA | EMIR | EMEA | EMIR |
105 | EMEA | EMIR | EMEA | EMIR |
106 | EMEA | EMIR | EMEA | EMIR |
I tried Join function with distinct feature but the results are not as shown above.
Can you please let me know which is the best way to join those 2 tables?
Regards,
Try this:
Load
Reference,
Region,
Regulator
From Table1 ;
Left join
Load
Reference,
Static_region,
Static_Regulator,
Static_region as Region, // join field
Static_Regulator as Regulator //join field
From
Table2;
Andrzej, did Vegar's solution work for you? If so, please consider using the Accept as Solution button on his post to give him credit and let others know this worked for you.
Here is the Help link for Join as well, just in case you are still working on things, may help you sort something if you are still trying to figure something out here.
Regards,
Brett