HOW TO CREATE A CASE STATEMENT IN TRANSFORMER
Posted: Tue Jan 24, 2006 3:56 am
Hello,
I have 2 tables: 1. Country 2. Language
In the country table for each Country there are ALL the languages available - meaning: Country = FR Language = US,NL,DE ....
Country Language
FR______US
FR______NL
FR______FR
What I am trying to create is for each country only the relevant languages + English(US)
In PL/SQL it would look something like the following:
case when country = 'FR' and (language = US or language = FR ) then language
case when country = 'NL' and ( language = US or language = NL ) then language
end case - ( No ELSE statement)
I don't mind Hardcoding the statement.
but I need to do it within DS
Any solutions will be welcome.
I have 2 tables: 1. Country 2. Language
In the country table for each Country there are ALL the languages available - meaning: Country = FR Language = US,NL,DE ....
Country Language
FR______US
FR______NL
FR______FR
What I am trying to create is for each country only the relevant languages + English(US)
In PL/SQL it would look something like the following:
case when country = 'FR' and (language = US or language = FR ) then language
case when country = 'NL' and ( language = US or language = NL ) then language
end case - ( No ELSE statement)
I don't mind Hardcoding the statement.
but I need to do it within DS
Any solutions will be welcome.