Problem in defining one business rule in transformer
Posted: Thu Mar 12, 2009 2:46 am
Hi All,
I have to give one condition in transformer. I am using a stage variable to do this.But the job is getting aborted because of that particular condition.I am not able to find out whats wrong in the below condition.
If Trim(Move_Xfm.Make)='Chevrolet' And Trim(Move_Xfm.Model)='Impala' And Trim(Move_Xfm.ModelYear) >='2006' And Trim(Move_Xfm.prfx) [4,2]= 'WS' Then 'E'
Else If (Trim(Move_Xfm.Make)='Chevrolet' Or Trim(Move_Xfm.Make)='GMC') And Trim(Move_Xfm.ModelYear) > '2007' And (Trim(Move_Xfm.prfx) [5,2]= 'C0' Or Trim(Move_Xfm.prfx) [5,2]= 'K0') Then 'E' Else ''
Can anybody help me out.
Thanks
I have to give one condition in transformer. I am using a stage variable to do this.But the job is getting aborted because of that particular condition.I am not able to find out whats wrong in the below condition.
If Trim(Move_Xfm.Make)='Chevrolet' And Trim(Move_Xfm.Model)='Impala' And Trim(Move_Xfm.ModelYear) >='2006' And Trim(Move_Xfm.prfx) [4,2]= 'WS' Then 'E'
Else If (Trim(Move_Xfm.Make)='Chevrolet' Or Trim(Move_Xfm.Make)='GMC') And Trim(Move_Xfm.ModelYear) > '2007' And (Trim(Move_Xfm.prfx) [5,2]= 'C0' Or Trim(Move_Xfm.prfx) [5,2]= 'K0') Then 'E' Else ''
Can anybody help me out.
Thanks