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

[agigliotti]

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

[D19PAL]

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.

[agigliotti]

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