Hello all,
I have a problem with a left join not working properly...
I have a first table like this (sql is a bit complicated so I cut, but it works !) :
OCCUP:
LOAD *;
SQL
SELECT UFM,pdate,COUNT(DISTINCT sejo_id_pati) NBPAT
FROM (
... ) GROUP BY UFM,pdate
ORDER BY UFM,pdate
;
What I want is add a new variable from an excel file depending on the UFM variable.
So I did this :
LEFT JOIN(OCCUP)
LOAD
UFM,CAPACITE
FROM [$(vCAPACIT)]
(ooxml, embedded labels, table is Feuil1);
The new variable is there but its empty...
And when I load the 2 tables separatly, all is good with a join between them.
I have tested that all distinct UFM in OCCUP are present in the second table.
I also tried to load the 2 tables and then join them but didn't worked
So, Im asking to you !
Thx for your help !