Transformer derivation

scorpion · Post by **scorpion** » Thu Sep 06, 2007 7:36 am

Hi All,

I need to write some derivation in my transformer like below:

if sourcecolumn1= 300 or 300% then populate 'xx'else blank.

my intension is, if the values are in source like 300 or 30045 or 30076 or 30088etc,whatever starts with 300 i need to populate as 'XX'.

SO below logic will work
IF sourcecolumn1='300%'then 'XX'else ''

?(will this look exactly for 300% or any thing starts with 300?)

can any one help me on this?

Maveric · Post by **Maveric** » Thu Sep 06, 2007 7:43 am

Convert the values to string and get the first 3 characters using substring. Compare them using CompareNoCase(%string1%,%string2%) function in transformer.

scorpion · Post by **scorpion** » Thu Sep 06, 2007 7:48 am

Hi Maveric Thanks for the reply,

It is very usefull forme,if you help me by giving exact derivation to me.

Maveric · Post by **Maveric** » Thu Sep 06, 2007 7:53 am

You need to declare the sourcecolumn1 as varchar. Conversion from int to varchar will be implicit. so dont have to worry abt it.

IF CompareNoCase(sourcecolumn1[1,3],300) then 'XX 'else ''

scorpion · Post by **scorpion** » Thu Sep 06, 2007 8:58 am

Hi,

Will Left function work in my scenario(means for integer type)?
Left((inputcolumn), 3)="700" or
Left((inputcolumn), 3)="701"

Maveric · Post by **Maveric** » Thu Sep 06, 2007 9:01 am

You will have to tell me. Did u try it? What other options have you tried?

ray.wurlod · Post by **ray.wurlod** » Thu Sep 06, 2007 4:17 pm

Left() is a string function and [] (substring operator) is a string operator - you would need to convert the integer to a string to be able to use either Left() or [substring] notation.