topic Question on tmap to use Or condition in join in Talend Studio

Question on tmap to use Or condition in join

_AnonymousUser — Mon, 22 Apr 2013 19:19:33 GMT

Hi,
I would like to use or condition tmap while joining with a lookup table. Can anyone share how that can be done? Below, i have given the table structure and join query. I want to achieve join query using tmap. How can i do that?
Table A (Main Table)
----------
Name,
Id_1,
Id_2
Table B (Lookup Table)
------------
Table B (Lookup)
------------------
Id,
Address,
Region
SELECT A.NAME, B.ADDRESS, B.REGION
FROM A, B
WHERE A.ID_1 = B.ID OR A.ID_2 = B.ID

Re: Question on tmap to use Or condition in join

alevy — Tue, 23 Apr 2013 00:09:52 GMT

The best way, I think, is to have two left-join lookups from Table B with an appropriate condition on your output e.g. Lookup1.Address != null || Lookup2.Address != null

Re: Question on tmap to use Or condition in join

Anonymous — Tue, 23 Apr 2013 03:26:58 GMT

Hi sree,
To make you clear, I have designed a demo job with troubleshoots.
Here are two files
1(main)
id;id1
12;24
13;26
15;30
2(lookUP)
id;name;address;region
12;dan;uk;LD
26;petter;uk;SF
15;merry;US;NY
24;shong;china;hn
60;sabrina;china;bj
The work flow is : tFileInputDelimited-->tMap-->tLogrow
Please see the screenshots for details

Best regards
Sabrina

Re: Question on tmap to use Or condition in join

_AnonymousUser — Tue, 23 Apr 2013 18:14:12 GMT

Thanks for the replies. I will try and let you know if there are more questions.

Re: Question on tmap to use Or condition in join

Anonymous — Fri, 15 Jun 2018 11:11:29 GMT

Re: Question on tmap to use Or condition in join

manodwhb — Fri, 15 Jun 2018 13:28:27 GMT

Try this way.

row1.id==row2.id1 || row1.id==row2.id2

Re: Question on tmap to use Or condition in join

Anonymous — Fri, 15 Jun 2018 13:37:07 GMT

Thank You So much @manodwhb.

It works very well.

Re: Question on tmap to use Or condition in join

Prasanna3 — Tue, 14 May 2019 18:22:48 GMT

If any column having null data then will get nullpointer exception right?

Re: Question on tmap to use Or condition in join

jeoste — Fri, 29 Nov 2019 16:14:56 GMT

Does this example still works ? I tried the same job, with same data and components. I can read the data in input, from the tFileInputDelimited, but my output is empty ; it looks like the join / condition does not work.

Any ideas ?