Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Probably a left join based on the Country column.
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$);