topic Filter Row if value is integer in Talend Studio

Filter Row if value is integer

Anonymous — Wed, 10 Apr 2019 11:31:19 GMT

Hello,

I have an excel input in the below format: And I need to filter out whatever is non integer.

ProjectNumber	TaskNumber
107	AT
108	AT
108	C-NON
109	119
109	120
109	121
109	122
109	123
109	124
109	AT
109	C-NON
12518-1	AT
12518-1	C-NONSCA

I need the output as below:

ProjectNumber	TaskNumber
109	119
109	120
109	121
109	122
109	123
109	124

Can anyone please suggest any solution.

Thanks

Re: Filter Row if value is integer

Anonymous — Wed, 10 Apr 2019 11:50:23 GMT

Hi,

I believe you are looking for this solution.

The component details are as below.

You will have to download the jar commons-lang-2.2.jar to use the class NumberUtils. This can be achieved through tLibrarayLoad.

Now, use a tMap to separate the data based on the condition as shown below.

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: Filter Row if value is integer

Anonymous — Wed, 10 Apr 2019 12:27:28 GMT

Hi Nikhil,

Thank you so much for the quick response. Really appreciate it. Should I download the jar from talend studio (Help->Download additional packages) or should I install it externally ?

Also after I open the component I see the following options. Will be really grateful if you could guide me through this.

Re: Filter Row if value is integer

akumar2301 — Wed, 10 Apr 2019 12:36:14 GMT

1) if you define your schema as Integer , it will reject non-numeric as Input level itself. ( un-tick "Die of error")

2) if you want to read as String and then check it can be done using regex also ( if you do not want to use external library ) .One option other than tMap could be tFilterRow.

Re: Filter Row if value is integer

Anonymous — Wed, 10 Apr 2019 12:50:14 GMT

Thank you Abhishek.. worked well..