topic equals with multiple data ? in Talend Studio

equals with multiple data ?

Eric_Talend — Fri, 15 Nov 2024 23:32:01 GMT

Hi,

In a tMap component, I do this :

(

!CAS1.ID.equals("101")

!CAS1.ID.equals("102")

!CAS1.ID.equals("110")

...

)

This code is OK but for me, this code is not "nice" and I search to make better this code.

I find something like this in MySQL :

select id from table where id IN ('a', 'b', ...)

It is possible to do something like this with Talend ?

Kind regards.

Re: equals with multiple data ?

Anonymous — Thu, 11 Nov 2021 03:40:16 GMT

Hello,

You can achieve this goal by using tMySqlInput component with context value in your Where clause.

The syntax looks like "SELECT id FROM mytable WHERE id IN '"+context.myvariable + "'"

The best way to approach this is to build your SQL query, output it to the System.out and then test the String you see in a query analyzer. If it works there, it will work in your DB component.

Best regards

Sabrina

Re: equals with multiple data ?

Mahamoutou — Mon, 15 Nov 2021 15:10:08 GMT

I think below condition using java contains method would be nicer (assuming comma is your separator).

! ( "," + "101,102,103,104,105,106" + "," ).contains( ("," + CAS1.ID + ",") )

You can easily expand your listOfValues "101,102,103,104,105,106" separated by a comma as you like.

Re: equals with multiple data ?

gjeremy1617088143 — Fri, 19 Nov 2021 08:59:59 GMT

Hi you can use regular expressions :

!CAS1.ID.matches("101|102|110")

Send me love and kudos