Join not working

[D19PAL]

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

[Lauri]

When you do a load like this -- the same fields without calculations -- Qlik doesn't behave well (in my opinion). I think it's being hyper-efficient. You can get around this by adding a dummy field, like:

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

Drop Field dummy;