DSXchange

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?

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

Hi Maveric Thanks for the reply,

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

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 ''

Hi,

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

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

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.