Is it possible to translate the content of your database?

[#1]

I am able to translate text when I indicate the actual Value, like f.e:

Only({<English={   Arrival    }>} [$(=vDataLanguage)])

Whet I cannot get to work is when the content of the database is Arrival.

I tried this:

=Only({<English={  [Event Type]  }>}   [$(=vDataLanguage)])

Where the [Event Type] database field has the content "Arrival".

Is it possible what I am trying to do?

Thanks in advance.

[swuehl]

Your both versions worked just fine at my site. Hmm, I think we probably have differing data models.

You are not able to open my apps, but I am able to open yours. Maybe you could post a small sample app here?

(upload is available in the advanced editor).

Regards,

Stefan

[swuehl · Accepted solution]

Hi Erik,

I also got this working as calculated dimension:

=FieldValue('$(vDataLanguage)',FieldIndex('English',[Event Type]))

Here you need to assure that your field values in your translation table are distinct, otherwise the lookup will probably deliver incorrect results. I think this should be the case for your translation table.

I also assumed (with both approaches) that your translation table is a data island, is this correct?

[#4]

Great!!!

This works.

Again thanks. I really appriciate it.