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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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;