topic Re: Implementing LIKE logic in Tmap in Talend Studio

Implementing LIKE logic in Tmap

sushantk19 — Sat, 16 Nov 2024 02:20:20 GMT

Hi,

I have to implement the below logic in Tmap:

If sku starts with ‘DE-TB%’ then ‘TB’

Elseif sku starts with ‘DE-SB%’ then ‘SB’

I tried something like below, but its not working

row4.SKU.contains("DE-TB%")?"TB":row4.SKU.contains("DE-SB%")?"SB":row4.SKU.contains("DE-SP%")?"SP":row4.SKU.contains("DE-LB%")?"LB":row4.SKU.contains("DE-WB%")?"WB":row4.SKU.contains("DE-DB%")?"DB":row4.SKU.contains("DE-CM%")?"CM":row4.SKU.contains("DE-PS%")?"PS":row4.SKU.contains("DE-PB%")?"PB":row4.SKU.contains("M1-TA%")?"TA":row4.SKU.contains("M1-PD%")?"PD":row4.SKU.contains("M1-PL%")?"PL":row4.SKU.substring(5,6)

if it doesnt match, then it should give the substring as from 5th position - 6 chars. How do i implement this?

Re: Implementing LIKE logic in Tmap

TRF — Mon, 25 May 2020 18:04:39 GMT

At least replace "contains()" by "startsWith()"

Re: Implementing LIKE logic in Tmap

sushantk19 — Mon, 25 May 2020 18:19:38 GMT

Startswith is not working. Any other way we can do that?basically I want to use LIKE clause % in my query

Re: Implementing LIKE logic in Tmap

TRF — Mon, 25 May 2020 18:26:16 GMT

@sushantk19 wrote:

Startswith is not working.

What doesn't work?

Do you any error?

Any compilation error?

Just an unexpected resulted?

What else?

Re: Implementing LIKE logic in Tmap

sushantk19 — Mon, 25 May 2020 18:29:46 GMT

yes, the output is not as expected. No errors as such.

As per the above mentioned logic, it is not able to read the input values such as "DE-TB%". It skips this condition and directly executes the else part.

Re: Implementing LIKE logic in Tmap

TRF — Mon, 25 May 2020 18:35:21 GMT

With Java your don't need the %.

Try this one:

row4.SKU.startsWith("DE-TB") ? "TB" :
    row4.SKU.startsWith("DE-SB") ? "SB" :
        and so on...

Re: Implementing LIKE logic in Tmap

sushantk19 — Mon, 25 May 2020 18:41:07 GMT

worked perfectly fine!! thank so much!

issue was I was using % symbol like row4.SKU.startsWith("DE-SB%")