Join 2 tables

[pelamis22]

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,

[Vegar]

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;

[Brett_Bleess]

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.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

Regards,
Brett