Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

link

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.

          

0 Replies