Join with ranges of time

[Anonymous]

Hi everybody,

I'm doing a join with ranges of time. The problem is the tmap component is doing an inner join forgetting all the rows in the first table without coincidence. I think this is caused because I'm doing it like a filter. Does anybody know if it's possible do this like a left join?Right now, I'm loading the data again and I'm doing a left join with a tmap using the first transformation like a lookup. 

By the way, 
FECHA_INICIO = START DATE
FECHA_FIN = END DATE
TIMESTAMP = DATE



Thanks!!

[Anonymous]

Can you show sample input and expected output? without that I don't think I understand your question