Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (2)
13 Replies
Highlighted
Partner
Partner

Re: Data missing after joining two tables

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
Highlighted
Partner
Partner

Re: Data missing after joining two tables

Highlighted
Partner
Partner

Re: Data missing after joining two tables

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

Highlighted
Creator II
Creator II

Re: Data missing after joining two tables

still not working.

Highlighted
Creator II
Creator II

Re: Data missing after joining two tables

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.

Highlighted
Partner
Partner

Re: Data missing after joining two tables

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
Highlighted
Partner
Partner

Re: Data missing after joining two tables

could you show your expected result in UI ?

Highlighted
Creator II
Creator II

Re: Data missing after joining two tables

i tried this solution and still not working.

Highlighted
Partner
Partner

Re: Data missing after joining two tables

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

I can walk on water when it freezes