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
to filer out data based on particular value
Moderators: chulett, rschirm, roy
to filer out data based on particular value
thanks n regards
nani
nani
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 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.
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.
Last edited by vasa_dxx on Mon Dec 22, 2008 2:47 am, edited 1 time in total.
Two wrongs don't make a right. But three lefts do.
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am