topic applying multiple filters iteratly on a dataset ? how to ? in Talend Studio

applying multiple filters iteratly on a dataset ? how to ?

iztoogood — Wed, 20 Mar 2019 13:27:44 GMT

Hello,

I have a data set... i have multiple filter to apply on this dataset...

how can y manage to iteratively apply those filter on my datas ?

maybe with a tMap ?... do yo have any idea ?

filters elements list:

|=-----+--------+-----=|
|left  |operator|right |
|=-----+--------+-----=|
|row1.A|>       |5     |
|row1.A|>       |row1.B|
'------+--------+------'

dataset:

.-+-.
|A|B|
|=+=|
|1|2|
|9|3|
|4|4|
|5|6|
|7|6|
'-+-'

here is what i'm trying to do :

Re: applying multiple filters iteratly on a dataset ? how to ?

akumar2301 — Wed, 20 Mar 2019 14:16:53 GMT

in Java , Usually it is not possible to evaluate code at run-time.

But it might be possible with tGroovy ( Only if it is simple use case) as it is a scripting/Programming Language. But then also lot of coding would be required.

Some examples below

https://www.programcreek.com/java-api-examples/?class=groovy.lang.GroovyShell&method=evaluate

Let me know if you find any other interesting solution.

Re: applying multiple filters iteratly on a dataset ? how to ?

iztoogood — Wed, 20 Mar 2019 14:48:31 GMT

Hi,

thanks Akumar... i will take a look