topic Re: how to use context variable in a tMap output filter section in Talend Studio

how to use context variable in a tMap output filter section

Vinlogs — Fri, 11 Feb 2022 12:28:25 GMT

Hi All, I am Currently reading data from a source file and I want to filter specific records from a column row1.abc and I am using the below condition

" row1.abc == 1 || row1.abc ==2|| row1.abc ==3 " in tMap output side filter section.

Requirement- I want to pass the values 1,2,3 to the above expression using a context variable in tMap output filter. Please help me how to achieve this. Thanks in advance..!😊

Re: how to use context variable in a tMap output filter section

gjeremy1617088143 — Fri, 11 Feb 2022 13:08:32 GMT

Hi, so you want all the values in one variable or one variable for each value ?

Send me love and kudos

Re: how to use context variable in a tMap output filter section

Vinlogs — Fri, 11 Feb 2022 13:21:32 GMT

Hi, Thanks for responding. I want all values in one context variable if possible.

Re: how to use context variable in a tMap output filter section

gjeremy1617088143 — Fri, 11 Feb 2022 14:59:12 GMT

use a context variable

here the name i use is list1 and value is "1,2,3" as String

then in a tJava a the begining of the job

in advanced settings of the tJava:

import java.util.List;

import java.util.ArrayList;

import java.util.Arrays;

in the basic settings of the tJava :

List<String> str = (Arrays.asList(context.list1.split(",")));

List<Integer> intList = new ArrayList<>();

str.forEach(a-> intList.add(Integer.parseInt(a)));

globalMap.put("intList", intList);

and in the tmap filter output expression :

((List<Integer>)globalMap.get("intList")).contains(row1.abc)

send me love and kudos

Re: how to use context variable in a tMap output filter section

Vinlogs — Mon, 14 Feb 2022 08:41:16 GMT

I have defined the code in tJava component as you mentioned and created a context variable with string data type and inserted value 22,38,39 in contexts section. But I am getting below error-please advise.

Re: how to use context variable in a tMap output filter section

gjeremy1617088143 — Mon, 14 Feb 2022 09:01:19 GMT

could you go to the code view and share screen where the error is. you can find it where there is red square. cause i test this particular piece of code and it's working

Re: how to use context variable in a tMap output filter section

gjeremy1617088143 — Mon, 14 Feb 2022 09:43:12 GMT

Re: how to use context variable in a tMap output filter section

Vinlogs — Mon, 14 Feb 2022 10:51:57 GMT

Thanks for sharing your screenshots, I am not able to see any errors in code view. But after I changed my string data type context variable value with enclosed double quotes "22,38,39" I am getting below error upon job run - {"logTimestamp":1644835697403,"severity":"FATAL","logType":null,"logMessage":"tJava_3 For input string: \"\"\njava.lang.NumberFormatException: For input string: \"\"\n\tat java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)\n\tat java.lang.Integer.parseInt(Integer.java:592)\n\tat

Re: how to use context variable in a tMap output filter section

Vinlogs — Wed, 23 Feb 2022 16:57:01 GMT

Thanks, @guenneguez jeremy !! The solution you provided did work. Appreciate your detailed solution with screenshots. Love and Kudos!