Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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.