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
ali_hijazi
Partner - Master II
Partner - Master II

join(Assignment)
load * resident Vacancies;
this will do an full outer join if there is at least on common column between the two tables

and if you leave the tables to link via the common column you will get the desired results

I can walk on water when it freezes
ali_hijazi
Partner - Master II
Partner - Master II

agigliotti
Partner - Champion
Partner - Champion

let's try to not join the two tables, leave them separate and linked with a unique key field.

elie_issa
Creator II
Creator II
Author

still not working.

elie_issa
Creator II
Creator II
Author

this is what we have done before founding that there is data missing from vacancy table which doesn't have a data in the assignment table and the link is vacancy id.

ali_hijazi
Partner - Master II
Partner - Master II

is the common column alphanumeric?
I mean it got values that are numbers and others that contain characters; or numbers with leading zeros?
if this is the case then you need to explicitly use the text function as follows:
load text(common_column) as common_column in both load statements of the two tables

I can walk on water when it freezes
agigliotti
Partner - Champion
Partner - Champion

could you show your expected result in UI ?

elie_issa
Creator II
Creator II
Author

i tried this solution and still not working.

ali_hijazi
Partner - Master II
Partner - Master II

Send please a screenshot of what you are seeing and what you expect to see

I can walk on water when it freezes