topic Re: How to acheive this <= join condition in tjoin or tmap component in Talend Studio

How to acheive this <= join condition in tjoin or tmap component

venkatadilip — Thu, 30 Jul 2020 21:57:18 GMT

Hi,

I have this query

select TBL1.*

from TBL1,

TBL2

inner join

ON trim(TBL1.ROWID)=trim(TBL2.ROWID)

CAST(CAST(TBL2.CREATE_DATE AS TIMESTAMP) as DATE)<=CAST(CAST(TBL1.CREATE_DATE AS TIMESTAMP) as DATE)

which needs to be translated into Talend job.

first join condition (

trim(TBL1.ROWID)=trim(TBL2.ROWID)) is not a problem to achieve

but how to implement the second join condition CAST(CAST(TBL2.CREATE_DATE AS TIMESTAMP) as DATE)<=CAST(CAST(TBL1.CREATE_DATE AS TIMESTAMP) as DATE) is what i need help with...

How to translate the second joining condition in Talend??

Re: How to acheive this <= join condition in tjoin or tmap component

manodwhb — Fri, 31 Jul 2020 00:46:29 GMT

You need do cross join and then in tMap output section enable filter with that condition.

Re: How to acheive this <= join condition in tjoin or tmap component

venkatadilip — Mon, 03 Aug 2020 18:03:02 GMT

Thank you @Manohar B