DSXchange

Posted: **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

Posted: **Mon Dec 22, 2008 12:19 am**

using filter stage

Posted: **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

Posted: **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.

Posted: **Mon Dec 22, 2008 1:37 am**

yes,

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

Posted: **Mon Dec 22, 2008 4:14 am**

Thanks .Its Working

DSXchange

to filer out data based on particular value

to filer out data based on particular value