Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Vicent,
Revenue.LoadPlace&' - '&Revenue.LoadUnplace as NewField,
Regards, Ferran.
if you are trying to create a simple calculated dimension, you can use
LoadPlace&' - '&UnloadPlace
in the dimensions.
Try with a edited dimension something like:
LoadPlace & ' - ' & UnloadPlace
as your new dimension
Hi Vincent,
Use calculated Dimension.
in that add LoadPlace &'-'& UnloadPlace.
Thank you.