How can we write a label expression?

[mohan_1105]

Hi,

I suppose wanted to write a label expression for the expression I loaded using GMS service. I tried using the demo expression, I manually enter the label expression in the master library and when I do a small correction in the excel sheet and reload the service. I see the manually entered label expression disappeared.

Is there is any way to write a label expression on the excel sheet itself?

Regards,

Mohan

[Ralf_Heukäufer]

You can use Variables for that:

Set Variables using excel file

Or if you want more than one language you can work with id´s in a excel file

ID               German               Englisc

1                 Haus                   house

and use

=only({<No = {1}>} German)

=only({<No = {1}>} English)

you can also use a variable for that

=only({<No = {1}>} $(v_language))

and set the variable in an extension by buttons for example

[mohan_1105]

Hi Ralf,

Can explain in detail about how label expression(Set variable) can be written when I'm using GMS demo excel?

[Ralf_Heukäufer]

Can you first explain me what you mean with GMS demo excel?

[mohan_1105]

Governed Metrics Service‌ I am using this service.

[Ralf_Heukäufer]

Unfortunately I have no experience with GMS. So I understand your question wrong. My answer works when you read a excel file direct in your load script.