topic Re: Join not working in QlikView

Join not working

D19PAL — Fri, 05 Mar 2021 14:26:59 GMT

Hi Guys

Can someone tell me why I can't see time_spamp in my FactTemp, following this code.

Lak

FactTemp:
NoConcatenate
LOAD
id
FROM [lib:******.qvd] (qvd);;

left join (FactTemp)
LOAD
id,
first_id as fi
Resident *******;

left join (FactTemp)
LOAD
id as fi,
date(floor(timestamp)) as time_stamp
Resident *******;

Drop Table ********;

exit script

Re: Join not working

agigliotti — Fri, 05 Mar 2021 14:39:40 GMT

Hi @D19PAL

For sure because the values of field "id" in "FactTemp" table doesn't exists in field "id" of table *******.
That's why you see null in field "time_stamp" of "FactTemp" table.

Best Regards

Re: Join not working

D19PAL — Fri, 05 Mar 2021 14:44:05 GMT

I wish it was that simple, I've tested fields and matching values, I can see matches, but they go once I drop the table. They don't remain.

Re: Join not working

agigliotti — Fri, 05 Mar 2021 16:32:17 GMT

could you post a sample qvw to take a look at?