Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
arethaking
Creator II
Creator II

How to join these tables?

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?

2 Replies
psk180590
Creator III
Creator III

Probably a left join based on the Country column.

micheledenardi
Specialist II
Specialist II

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$);