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.
If then else problem
Moderators: chulett, rschirm, roy
If then else problem
somaraju