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.
What could be the solution ?
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
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.
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