topic Re: Join 2 tables in QlikView

Join 2 tables

pelamis22 — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Join 2 tables

Vegar — Thu, 05 Sep 2019 12:58:57 GMT

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;

Re: Join 2 tables

Brett_Bleess — Thu, 05 Sep 2019 12:59:35 GMT

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/ScriptPrefixes/Join.htm

Regards,
Brett