Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
let's try to not join the two tables, leave them separate and linked with a unique key field.
still not working.
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
could you show your expected result in UI ?
i tried this solution and still not working.
Send please a screenshot of what you are seeing and what you expect to see