topic Re: expression filter causing issue in Talend Studio

expression filter causing issue

Anonymous — Fri, 13 Apr 2018 01:51:15 GMT

Hi, I have to put the following condition in my Tmap ie

when name='ABC' and year=2010 to 2017, then only give o/p. name is coming from Datasource1 and year from Datasource2

so in Tmap, I created this expression filter and it doesn't work.

(Datasource1.name=="ABC" && (Datasource2.year >=2010 && Datasource2.year <=2017))

What is wrong with it..? Thanks in advance for help!

Re: expression filter causing issue

mks02 — Fri, 13 Apr 2018 07:35:02 GMT

I took 2 excel files and join with tMap using your filter. Its working perfectly there.
File 1 Schema: ID (int), NAME (string)
File 2 Schema: ID (int), Year (int)

File1.NAME.equals("ABC") && (File2.YEAR >=2010 && File2.YEAR <=2018)

--> '==' operator compares two object references to see whether they refer to the same instance.
--> equals() method compares the characters inside a String object i.e. compare the data.

Hope it helps.

Re: expression filter causing issue

Anonymous — Fri, 13 Apr 2018 15:24:02 GMT

Thanks, I tried using the same logic. and it throws some java error.

3.png

Re: expression filter causing issue

mks02 — Sat, 14 Apr 2018 22:09:37 GMT

No need to use the logic in VAR area. You need to put the filter in tMap Output table area.
Please see the attachment for more details.

Let me know if it helps.

TLND_tmap_exprFilter.PNG

Re: expression filter causing issue

Anonymous — Tue, 17 Apr 2018 20:16:46 GMT

Hi,

I don't put the expression in the VAR area. I put it in expression builder area only. Somehow it threw error. Is this expression working for u..?

Re: expression filter causing issue

mks02 — Wed, 18 Apr 2018 06:07:23 GMT

Yes, its working in my case.
After applying this code APPLY OK, just run the job. It will give desired result.

There is possibility that your system has more than 1 java versions, so you need to uninstall them, then reinstall which one you needed.

Re: expression filter causing issue

Anonymous — Wed, 18 Apr 2018 17:10:46 GMT

Hi Mk02,

Yes, I do have mutiple java versions. see below. which one should I keep..?

Re: expression filter causing issue

manodwhb — Thu, 19 Apr 2018 06:06:49 GMT

I Suggest you to unistall Java 10