topic tMap Lookup with multiple conditions in Talend Studio

tMap Lookup with multiple conditions

Anonymous — Mon, 10 Dec 2018 16:55:19 GMT

Hi,

I want to make a lookup based on a multi condition.

I generate people and I want to get the Age Category Label with this lookup condition
AgeMin<=People.Age AND People.Age<AgeMax

What are the differents ways please?

Yours Faithfully

DAURIAC Igor

Re: tMap Lookup with multiple conditions

Anonymous — Tue, 11 Dec 2018 06:01:46 GMT

Hi,

The neat an easy way to do is to add the condition in expression section of output tmap.

If you are happy with the solution, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: tMap Lookup with multiple conditions

zalibra — Thu, 26 Sep 2019 17:42:57 GMT

Hi Nikhil,

If I wanted to apply two completely separate conditions, how would I do it? When I do,

StringHandling.LEFT(row3.ResponseContent,StringHandling.INDEX(row3.ResponseContent,":")); row3.ResponseContent.replaceAll("\"","")

it doesn't work.

Re: tMap Lookup with multiple conditions

Anonymous — Thu, 26 Sep 2019 17:59:46 GMT

@zalibra

I could see that you are doing data assignment in the tMap condition check. You do not have to assign the values at the condition check area. Any data assignment (with or without column level condition) need to happen within the column level mapping.

Now, if you have to verify two conditions at same time, you can use operators like AND or OR symbols like I had mentioned in my previous post.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tMap Lookup with multiple conditions

zalibra — Thu, 26 Sep 2019 18:15:36 GMT

Thanks, Nikhil. I'm actually putting these two conditions at the column level mapping and have tried both AND and OR but it doesn't work. (screenshot attached).

I have a workaround where I use "StringHandling.LEFT(row3.ResponseContent,StringHandling.INDEX(row3.ResponseContent,":"))" in tMap and then use tReplace for "row3.ResponseContent.replaceAll("\"","")"

Instead of having multiple components (tMap and tReplace), I was wondering if these two conditions could be applied in one.

Test.png
tMap.png

Re: tMap Lookup with multiple conditions

Anonymous — Thu, 26 Sep 2019 19:31:43 GMT

@zalibra

Could you please try below logic?

StringHandling.LEFT(row3.ResponseContent,StringHandling.INDEX(row3.ResponseContent,":")).replaceAll("\"","")

Please note that if you do not have any ":" in the input string, the job will fail with Index error. In that case, you will have to add additional rules to avoid the error.

If the answer has helped you, please mark the topic as resolved.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tMap Lookup with multiple conditions

zalibra — Thu, 26 Sep 2019 19:51:02 GMT

Worked. Thanks! Point noted about the ":".