topic Re: Merging two data sources in QlikView

Merging two data sources

Wed, 25 Nov 2020 16:16:04 GMT

I have two data sources that I want to merge using 2 fields..

The two tables that would be joined are pictured below:

Basically what I'm trying to accomplish here is to be able to click on the ProgramAMDeptCTOAManager or [AM Impacted LOB] fields and have both of my data sets filter on those values, rather than have two instances of each field and have to filter them separately.

Do I need to simply join these tables together to accomplish this?

Re: Merging two data sources

Peter_Cammaert — Sun, 05 Jun 2016 16:05:38 GMT

Each value exists in only one table, and AFAIK there are no common fields that can be used as key fields. What is the relation between the two data sets? Put that relation in identical key fields in each table and QlikView automatically create the associative link. From that moment on, you can filter both data sets by selecting in a field that is only present in the first or the second table.

If you are sure that a real JOIN LOAD won't create doubles, or the doubles are not important, you can use a hard script JOIN to create a single table with everything inside.

Best,

Peter

Re: Merging two data sources

ziadm — Sun, 05 Jun 2016 17:50:16 GMT

in order to join tow tables there have to be a common key between the tables.

I do not see any common keys or identical field names in the tables above

Please refer to this document series on joining and linking tables concepts

Beginners Task Series - Task6(Self Join)

Re: Merging two data sources

Tue, 07 Jun 2016 20:51:14 GMT

The "common" thing between them is the [Impacted LOB] and ProgramAMDeptLOB have two of the same values:

What I want to be able to do is have ONE filter where I click GIM or GWM and both datasets filter on that value.. is that possible?

Re: Merging two data sources

Wed, 08 Jun 2016 06:30:32 GMT

Hi,

Not sure if this is what you're looking for. You can just rename [AMImpacted LOB] to ProgramAMDeptLOB or the other way around so 2 tables can have the common field name. then just do the outer join between those 2 tables based on that common field name.

LOAD *

Resident Impacts;

Outer Join

Load ProgramOSBDeptID,

ProgramAMDeptCTOManager,

[ProgramAMDeptCTO-1Manager],

ProgramAMDeptLOB As AMImpactedLOB,

[ProgramAMDeptSub-LOB]

Resident ProgramOSBDepartmentMapping;