topic Re: How to join these tables? in QlikView

How to join these tables?

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

Hi All,

I want to join SALES and Qty tables based on REGION,ID, need to get DATE.

I want to join SALES and Budget tables based on REGION,STATE,DIST,SECOND_DIST,START_DT,END_DT to get

REGION,ID,STATE,DIST,SECOND_DIST,START_DT,END_DT,Bugget1,Bugget2,Bugget3.

How to join?

Re: How to join these tables?

psk180590 — Mon, 27 Nov 2017 10:59:43 GMT

Probably a left join based on the Country column.

Re: How to join these tables?

micheledenardi — Mon, 27 Nov 2017 11:07:39 GMT

Could be something like:

Sheet1:
LOAD
    COUNTRY&'|'&GROUP&'|'&SUB_GROUP&'|'&SECOND_SUB_GRP&'|'&START_DT&'|'&END_DT as Key2,
    COUNTRY&'|'&SPLIT as Key1,
    COUNTRY,
    SPLIT,
    GROUP,
    SUB_GRP,
    SUB_GROUP,
    SECOND_SUB_GRP,
    SECOND_SUB_GROUP,
    SKILL,
    SKILL_NAME,
    START_DT,
    END_DT
FROM
 (biff, embedded labels, table is Sheet1$);


left join(Sheet1)
LOAD
    COUNTRY&'|'&SPLIT as Key1,
    DATE,
    OFFERED_CALLS
FROM
 (biff, embedded labels, table is Sheet2$);


left join(Sheet1)
LOAD
    COUNTRY&'|'&GROUP&'|'&SUB_GRP&'|'&SECOND_SUB_GRP&'|'&START_DT&'|'&END_DT as Key2,
    SL_TARGET,
    SL_THRESHOLD,
    AHT_TARGET
FROM  (biff, embedded labels, table is Sheet3$);