If then else problem

[somu_june]

Hi,

I have defined a stage variable Region and it is char and length 20 and in derivation section I defined as IF src.country = 'IN' then 'ASIA' Else if src.country = 'GE' then 'EUROPE' Else if src.country = 'US' then 'North America' Else 'Dummy' and source country column is char(30)

But Iam getting the output for the derivation even for IN, GE and US as 'DUMMY' instead of ASIA, EUROPE and NORTH AMERICA.

Can some one tell me where Iam going wrong in the derivation field


Thanks,
SomaRaju.

[DSguru2B]

Its defined as char(20) so 'ASIA' will have 16 trailing spaces. Change it to varchar and TRIM the column before doing your comparison.

[somu_june]

Hi,


Thanks for solving my problem






Somu