Left join isn't working...

LudoP — Tue, 30 May 2023 11:10:42 GMT

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 !

topic Left join isn't working... in App Development