script

[#1]

Hi all,

I got the data of loadplace/area/country and the place of unloadplace/area/country in my script:

Revenue.LoadPlace

AS LoadPlace,

Revenue.UnloadPlace

AS UnloadPlace,

now I want a dimension that shows me these 2 behind each other like:

Arnhem - Amsterdam

How to achieve this and it's probably the basics but I tried alot and just can't remember how to solve the issue.

kind regards

[its_anandrjs · Accepted solution]

As i under stand create another field in the load script

Revenue.LoadPlace AS LoadPlace,

Revenue.UnloadPlace AS UnloadPlace,

Revenue.LoadPlace &'-'& Revenue.UnloadPlace as Newfield  //Add new field

New Update:- Without adding that field in the Load statement you are do this in Dimension also like

Eg:-    Revenue.LoadPlace &'-'& Revenue.UnloadPlace

[Ferran_Garcia_Pagans]

Hi Vicent,

Revenue.LoadPlace&' - '&Revenue.LoadUnplace as NewField,

Regards, Ferran.

[srchilukoori]

if you are trying to create a simple calculated dimension, you can use

LoadPlace&' - '&UnloadPlace

in the dimensions.

[alexandros17]

Try with a edited dimension something like:

LoadPlace & ' - ' & UnloadPlace

as your new dimension

[#6]

Hi Vincent,

Use calculated Dimension.

in that add LoadPlace &'-'& UnloadPlace.

Thank you.