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: 
elie_issa
Creator II
Creator II

Data missing after joining two tables

Dear All,

we have two tables :

Assignments and Vacancies and the key is Vacancy id.

In our case we could have some vacancies without assignment (no vacancy id in assignment table) but we need to show them in our dashboard.

I tried to do the below outer join in my script but still without succeeding.

outer join(Assignments)

Load *

Resident Vacancies;

What could be the solution ?

ali_hijazi

13 Replies
elie_issa
Creator II
Creator II
Author

as shown in the attached picture the two tables are linked by Vacancy ID.

If we generate the vacancy table alone we have for example vacancy id : 3060

while this vacancy doesn't have a row in the assignment table.

when we reload the assignment table the vacancy id 3060 will not show.

I have tried the outer join , join and now as shown in the attached pic i tried not to join the two tables, leave them separate and linked with a unique key field (vacancy id) but no solution till now.

agigliotti
Partner - Champion
Partner - Champion

what is your current output and what is your expected result ?

enricocamerin
Creator
Creator

shouldn't be the opposite ?

outer join(Vacancies)

Load *

Resident Assigment;

elie_issa
Creator II
Creator II
Author

we found now that the problem is from the section access security because we are making the security on a field found in the assignment table and in this case the field will be null if no assignment then the record is removed :S and we need to do the security in such way.