Hi,
Using a translation table I want to change the labels of the columns in a chart according the chose language.
For example:
Translate:
Load * inline
[
Field,Dutch,French, English
AXB_NR,Nummer, Numero, Number
TMSS_BDR,Bedrag, Montant, Amount
CAP_NM,Naam, Nom, Name
];
The language is stored in the variable vLanguage, namely: Dutch,French or English
I translate the individual labels of the columns in the chart in this way:
=FieldValue($(vLanguage), FieldIndex('Field','AXB_NR')) --> label for column AXB_NR in the language in vLanguage
=FieldValue($(vLanguage), FieldIndex('Field','TMSS_BDR')) --> label for column TMSS_BDR in the language in vLanguage
=FieldValue($(vLanguage), FieldIndex('Field','CAP_NM')) --> label for column CAP_NM in the language in vLanguage
but it would be practical that I don't have to refer to the column name literally , but use a sort of variable $ThisColumnName
For every label I could use the same expression:
=FieldValue($(vLanguage), FieldIndex('Field',$ThisColumnName))
Is this possible?
Thanks