Pls tell me expression ?

[#1]

My Condition is   where   PIN='122001' or '122002' or '122003'  then output is   hyd   if its  not    then  output  is   banglore 

pls  TELL ME  FOR THIS  CONDTION  I  WANT  WRIGHT  A   LOGIC  I  AM  VERY  BAD   IN WRITING  LOGICS

[swuehl]

=if(match(PIN, '122001', '122003'), 'hdy','banglore')

or in script

...

if(match(PIN, '122001', '122003'), 'hdy','banglore') as FIELD,

...

[#3]

as   filed means     we  nedd  to  write  field  name  here?   if   field  is   product   then   as  product?  pls   tell me  immediaately

[swuehl]

FIELD will be the new field containing the output of your conditional expression in the load. It's your turn to add more details about the context you want to create the expression. Some input data may also ve helpful.