Link Table

[Jacob]

Hi All,

I want to create link tables same as shown in the image below.H ow can I do in script plz help.

[sergio0592 · Accepted solution]

Hi,

Qlikview links table on field with the same name. So, use load inline in the load statement and you will get yours link table in the the table viewer (ctrl+T)

[Jacob]

can you please share the script.

[sergio0592]

Just use load inline in your load statement

SECTION_ACCESS:
LOAD *

INLINE [
NTNAME, ACCESS, USERID,
Username1,ADMIN,1
Username2,USER,2
Username3,ADMIN,3
Username4,USER,4]
;

USER_RIGHTS_LINK:
LOAD *
INLINE [
USERID,S.EmployeeID,E.EmployeeID
A,1,1
A,2,2
A,3,3
B,1,3
B,1,3
C,1,no
C,3,no
D,1,1
D,2,no
D,3,3
];

EMPLOYEE:
LOAD *
INLINE [
E.EmployeeID,Adress,Phone
1,Road,0899
2,Street,89668
3,City,68766
];

SALES:
LOAD *
INLINE [
S.EmployeeID, Value, Quantity
1,2500
2,1500
3,3500
];

[Jacob]

Hi

I have one question. I want to implement the same scenario in my project using the table from the data model. How can do?

[sergio0592]

It's a little fuzzy can you elaborate more please? What do you mean with "using the table from the data model. "