Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

elie_issa
Contributor 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
ali_hijazi
Honored Contributor

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

ali_hijazi
Honored Contributor

Re: Data missing after joining two tables

agigliotti
Honored Contributor II

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.

elie_issa
Contributor II

Re: Data missing after joining two tables

still not working.

elie_issa
Contributor 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.

ali_hijazi
Honored Contributor

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

agigliotti
Honored Contributor II

Re: Data missing after joining two tables

could you show your expected result in UI ?

elie_issa
Contributor II

Re: Data missing after joining two tables

i tried this solution and still not working.

ali_hijazi
Honored Contributor

Re: Data missing after joining two tables

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