sql server 2008 - PDI Check if a value exist in table and retain value for error notification purpose -

i doing loading vouchers sql server 2008 using pentaho.

i have voucherinfo table having fields, vouchername, voucherid, start date , end date, voucher information.

vouchermember table having fields, voucherid, memberid. show vouchers members entitled to.

i want load data vouchermember table if voucherinfo has field voucher want load in, if vouchertable not have, want retail value , send email user voucher deos not exist in voucherinfo table.

i have read database lookup , filter rows can achieve cannot retain value.

is there way in pentaho do?