I have a parameter table, in which the translation is stored per Country and per language
as following, categorized by param_type. The param_code is used for the mapping to extract the param_text . Note that there are not always translation (text) in all languages, if no text/translation is found, we show the code instead
param_type
param_country
param_langue
param_code
param_text
param_group
USA
EN
chd01
Demonstration
param_group
USA
FR
chd01
Démonstration
param_group
FRA
FR
chd01
démo FR
param_group
FRA
FR
chd01
démo FR
param_group
USA
FR
cheveryone
Région Everyone
param_group
FRA
EN
cheveryone
Region Everyone
param_group
FRA
FR
chl01
Linéaire 01
param_group
USA
EN
chl01
Linear 1
param_group
USA
EN
chl99
Key-Account
param_group
FRA
FR
chl99
k-accounts
param_system
USA
EN
sys1
System 1
param_system
USA
FR
sys1
Système 1
param_system
FRA
FR
sys1
Système 1
param_system
USA
EN
sys2
System 2
param_system
FRA
FR
sysw
Système 2
Data is store as following, we need to display on the interface (as dimension of a pivot table) the text/description corresponding to the codes: values in column "group_code" can be found within param_type = 'param_group' according to the Country (available in data rows and the application's language (do not available during scriptting, but via a variable vDataLanguage)
id
country
group_code
system_code
price
1
USA
chl01
sys1
100
2
FRA
chd01
sys2
200
3
USA
chl99
sys1
500
I need to achieve the following
If vDataLanguage = FR
ID
Country
Group
System
Price
1
USA
(chl01)
Système 1
100
(chl01 has no translation in USA / FR so we show the code)
2
FRA
démo FR
Système 2
200
3
USA
(chl99)
Système 1
500
(chl01 has no translation in USA / FR so we show the code)
If vDataLanguage = EN
ID
Country
Group
System
Price
1
USA
Linear 1
System 1
100
2
FRA
démo FR
(sys2)
200
(sys2 has no translation in FRA / FR so we show the code)
3
USA
Key-Account
System 1
500
I had followed a solution, which is add 2 additional columns per param_type ( for example group_text_EN, group_text_FR, etc...)into the Data table during load, using ApplyMap. Then once in the interface, I set up the expression inteads of a fixed field (If vDataLanguage = 'EN', group_text_EN, group_text_FR). The problem is, when a user select a value, in Active Selection box, we see both fields appeared (group_text_EN = 'value', group_text_FR='...'). Even worse because in reality I have 3 languages.
