Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to get all columns in table box

Hi,

I have one qvw file. I need to use Table Box.

It needs to use the data from three tables. I have link between those three tables. but when I am selecting columns it is getting blank values for one table columns could anyone let me know how to solve this please.

Organisation:

LOAD companyId   as EmployeeId

FROM
qvd;


CreditorClaims:

LOAD EmployeeId,


FROM
qvd;

Employee:

LOAD '1' as FLAG,
     EMPLOYEEID as EmployeeId,
FROM
qvd;

Thanks.

1 Reply
Not applicable
Author

Organisation:

LOAD companyId   as EmployeeId

FROM
qvd;


CreditorClaims:

LOAD EmployeeId,

FROM
qvd;

Employee:

LOAD '1' as FLAG,
     EMPLOYEEID as EmployeeId,
FROM
qvd;

total:

noconcatenate

load * resident Organisation;

inner join

load * resident CreditorClaims;

inner join

load * resident Employee;

drop tables Employee,CreditorClaims,Organisation;