Concatenate Dimensions

[DebbieFCMSB]

Hi 
I am a newbie to looker. How do i create a custom dimension by concatenating three dimensions that we currently have?

[fabio1]

Hi @DebbieFCMSB - Assuming you have explore access to create custom dimensions, and that the existing dimensions are of string type, you should be able to use the `concat` string function:

https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators#st...

If you have developer access and want to save the definition into your LookML model, I would just directly write the concatenation SQL into the new dimension using the relevant function/operator for your SQL dialect