Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please explain with One Simple Example
Hi Jai,
Thanks for your Response
Hi,
Try this sample script
Sales:
LOAD
A & '_' & B & '_' & C AS Key,
A,
B,
C,
Sales
FROM Table1;
LinkTable:
LOAD DISTINCT
A & '_' & B & '_' & C AS Key,
A,
B,
C,
'Sales' AS Flag
RESIDENT Sales;
DROP FIELDS A, B, C From Sales;
Budget:
LOAD
A & '_' & B & '_' & C AS Key,
A,
B,
C,
Budget
FROM Table2;
Concatenate(LinkTable)
LOAD DISTINCT
A & '_' & B & '_' & C AS Key,
A,
B,
C,
'Budget' AS Flag
RESIDENT Budget;
DROP FIELDS A, B, C From Budget;
Hope this helps you.
Regards,
Jagan.
Hi,
Attached document may help you.