topic Re: Context variable as filter in Talend Studio

Context variable as filter

_AnonymousUser — Wed, 08 Apr 2015 18:19:16 GMT

I would like to use context variables to filter the output records on the basis of the condition which I put in context variable.
To give and example.
My input file:
SlNo, Code
1,A
2,A
3,B
4,B
Now if my filter criteria of context variable say filter_code is A then only output records with Code A should be in output, and if B then only with Code B and if default then all the records

Re: Context variable as filter

Anonymous — Thu, 09 Apr 2015 08:21:14 GMT

you can do it using tMap configure context variable in filter expression and use something like below.

row1.slno.equals(context.parameter) || context.parameter.equals("Default")

Re: Context variable as filter

sunbaj — Thu, 09 Apr 2015 10:46:45 GMT

Will "Default" work as it is not a value in the column !!