i am using below script to create link table
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
T1:
LOAD id,
name,
id&'/'&name as key,
add,
sal
FROM
C:\Users\user\Desktop\Ex.xlsx
(ooxml, embedded labels, table is Sheet1);
T2:
LOAD id,
name,
id&'/'&name as key,
dep,
loc
FROM
C:\Users\user\Desktop\Ex.xlsx
(ooxml, embedded labels, table is Sheet2);
T3:
LOAD id,
gis,
tag
FROM
C:\Users\user\Desktop\Ex.xlsx
(ooxml, embedded labels, table is Sheet3);
linktable:
load Distinct
id,
name,
id&'/'&name as key,
add,
sal Resident T1;
Concatenate
load Distinct
id,
name,
id&'/'&name as key,
dep,
loc Resident T2;
Concatenate
load distinct
id,
gis,
tag
Resident T3;
drop Fields
id,
name
from T1,T2,T3;
but not able to create pls provide the correct script.