to filer out data based on particular value

nani0907 · Post by **nani0907** » Sun Dec 21, 2008 11:48 pm

Hi

my input data is like:

Column A Column B
1 PINK
2 pink
3 pInk
4 orange
5 ORANge

I need to filter out only Column B which has value 'pink'. the Value Pink is upper case some time,Lower case and combination of lower and upper case.

Please Help me

srinivas.g · Post by **srinivas.g** » Mon Dec 22, 2008 12:19 am

using filter stage

nani0907 · Post by **nani0907** » Mon Dec 22, 2008 12:31 am

here i am geeting column b values with different options like upper case, lower case and combination of both. how to check it

vasa_dxx · Post by **vasa_dxx** » Mon Dec 22, 2008 12:37 am

I don't think its quite possible through Filter Stage. Becuase, In Where parameter, You need to specify operators =, like, between.
So use a transformer. Use the derivation to filter after converting the I/p column to Lower or Upper Case.
output_link.col_b --->> lower(input_link.col_b)='pink'
This addresses the requirement.

srinivas.g · Post by **srinivas.g** » Mon Dec 22, 2008 1:37 am

yes,

constraint is
trim(DSLink2.column2) <> DownCase("pink")

nani0907 · Post by **nani0907** » Mon Dec 22, 2008 4:14 am

Thanks .Its Working