Page 1 of 1

eliminting certain rows

Posted: Tue Jul 04, 2006 10:43 am
by thatiprashant
hi,

i am having big probs with this data,i get a flat file with a data on product codes,like soapcode,pastecode,transactioncode,drinkscode,winecode and so on..everytime the transaction of any of these products go thru it will create a respective code,,but i dont need winecode and pastecode, beside that i need all the codes generated in that column, can someone pls help me to know how to filter those 2 records and move all other recors.

thanks in anticipation

prashant

Re: eliminting certain rows

Posted: Tue Jul 04, 2006 11:00 am
by DSguru2B
thatiprashant wrote:hi,

everytime the transaction of any of these products go thru it will create a respective code

prashant
Who creates those codes. Do you create them?
Well regardless, let them be there, pass them through a transformer and put the constraint not equal to those two codes.

Re: eliminting certain rows

Posted: Tue Jul 04, 2006 12:26 pm
by thatiprashant
DSguru2B wrote:
thatiprashant wrote:hi,

everytime the transaction of any of these products go thru it will create a respective code

prashant
Who creates those codes. Do you create them?
Well regardless, let them be there, pass them through a transformer and put the constraint not equal to those two codes.
THANKS GURU IT DID WORK

Posted: Tue Jul 04, 2006 11:20 pm
by kumar_s
how to filter those 2 records and move all other recors.
You also have filter stage specifically designed for this.