Comparing to various conditions

Hi,

What is the best way of doing the following thing in Advanced ETL Processor Ent.

If a source field "Country" attains different values according to following conditions:

Else If "Country" is among (Aus, Eng, SA, SL, Ind, Pak, Ire, NZ) then return value is "Base A"

Else If "Country" is among (Canada, US, Brazil,Swiz , Morocco, Afgan) then return value is "Base B"

Else If "Country" is among (Nigeria, Sene, Burma, Philip, Hondu) then return value is "Base C"

Else If "Country" is among (Tuni, Rio ) then return value is "Base D"

Else If "Country" = NULL then return value is "NULL"

Regards

Ayush

Case fucntion would be the best

www.etl-tools.com/articles/case-transformation.html

Hi Peter,

I could not get it. What I want is I have a target field as "Base" and based on the "country" which is my input, I want to fill values in "Base" field whether it is "BaseA" or "BaseB" or "BaseC" or "NuLL"

Thanks,

Ayush

Post your screeshots than, so we can correct it

Hi Peter,

Actually I am not able to think which field I should place where. In the example which you have sent I see [Phase1], [Phase2], [Phase3] but in my case there is only 1 target field i.e. "Base" and my input field is also 1, i.e. "Country" but I see 2 inputs in the example [Condition] and [Phase]. Not sure how is this example replicated in my case.

Thanks

Ayush

Here is a working example



PS.
We would really appreciate if from now on you will prepare sample data yourself before asking question

Mike