topic Re: Filter based on global Variable in Talend Studio

Filter based on global Variable

xfrancom — Fri, 06 Nov 2015 00:23:11 GMT

Hi,

I want to apply a custom filter from csv file if a condition is true
if this conditions = true -> ((Integer)globalMap.get("FiltraDiasSinStock") != 0)
Apply Filter -> row1.FechaUltimaEntrada.compareTo("") != 0 && row1.FechaUltimaEntrada.compareTo("25/11/2015") != 0
Else -> No filter is applied

Thank you

Re: Filter based on global Variable

Anonymous — Fri, 06 Nov 2015 07:01:50 GMT

Hi,

Could you please elaborate your case with an example with input and expected output values?

Ie seems you are looking for tenary operation in tmap: Condition?value if true: value if false
Please take a look at component TalendHelpCenter:tMap.

Best regards
Sabrina

Re: Filter based on global Variable

xfrancom — Fri, 06 Nov 2015 08:52:10 GMT

This is jus what i have tried in tmap/filter, but does'nt work when (Integer)globalMap.get("FiltraDiasSinStock") == 0 (else condition)

((Integer)globalMap.get("FiltraDiasSinStock") != 0) ?
(row1.FechaUltimaEntrada.compareTo("") != 0 && NormalizaFecha.ConvertSimpleDateFormat(row1.FechaUltimaEntrada).compareTo(TalendDate.addDate(TalendDate.getDate("yyyyMMdd"),"yyyyMMdd",(Integer)globalMap.get("FiltraDiasSinStock"),"dd")) > 0) :
true