Conversion in Transformer
Posted: Wed Feb 18, 2015 2:09 am
Hi,
I have source column Code char(9) which contains code in both forms numbers and letters like 161,ADG.
I'm using transformer where i have condition that when code is 112 then current timestamp else column2
Condition : if code = 161 then CurrentTimestamp() else column2
But im facing a problem when using above condition, its unable to match the number since its defined as char. May I know whats the best way to convert char, so that it can match both numbers and letters in the condition.
Can someone help me with this.
Regards,
Rajesh
I have source column Code char(9) which contains code in both forms numbers and letters like 161,ADG.
I'm using transformer where i have condition that when code is 112 then current timestamp else column2
Condition : if code = 161 then CurrentTimestamp() else column2
But im facing a problem when using above condition, its unable to match the number since its defined as char. May I know whats the best way to convert char, so that it can match both numbers and letters in the condition.
Can someone help me with this.
Regards,
Rajesh