How to filter the records

[sujaoschin]

input field has field of values "as_location"( VALUES,-SI, FA,FP) and "biseps_Md_ad_id"( 90002, 78582, OTHERS) which has to be lookup with MI_STATUS(VALUES LIKE SI, FA, FP) & MI_AD_ID(Values -90002, 78582, OTHERS)

TFM N logic is 'if Mi_status=fa and mi_ad_id=90002 then 105 to be populated in 'as_location'

TFM N logic is 'if Mi_status=fa and mi_ad_id=78582 then 104 to be populated in 'as_location'

TFM N logic is 'if Mi_status=fa and mi_ad_id<>90002 or <>78852 then reject the records in 'as_location'

How to filter using transformer stage?

[chulett]

You 'filter' by using a constraint. And those first two are derivations, while the third is what you would need to adopt for the constraint expression on the transformer's outbound link.

[sujaoschin]

This issue is resolved by writing the if command