How to join these tables?

[arethaking]

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?

[psk180590]

Probably a left join based on the Country column.

[micheledenardi]

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