Hi Chandini,
Check this small example of the Link tables which is small example please copy and paste this example for understand how link table works in this sample three tables used Sales, Budget and Customer master details.
Sales:
LOAD Year&'_'&Month&'_'&[Customer Number] as Key,[Sale Amt],Year,Month,[Customer Number];
LOAD * INLINE [
Year, Month, Customer Number, Sale Amt
2013, 4, A, 15874
2014, 5, B, 12569
];
Budget:
LOAD Year&'_'&Month&'_'&[Customer Number] as Key,[Budget Amt],Year,Month,[Customer Number];
LOAD * INLINE [
Year, Month, Customer Number, Budget Amt
2013, 4, A, 45000
2014, 5, B, 46000
];
Customer:
Load * Inline
[
Customer NO,Customer Name
A,Kim
B,Saun
];
LinkTable:
LOAD Key,Year as YEAR,Month as MONTH,[Customer Number] as [Customer NO] Resident Sales;
LOAD Key,Year as YEAR,Month as MONTH,[Customer Number] as [Customer NO] Resident Budget;
DROP Fields Year,Month;
SalesTable:
LOAD Key,[Sale Amt] Resident Sales;
DROP Table Sales;
BudgetTable:
LOAD Key,[Budget Amt] Resident Budget;
DROP Table Budget;
