Question

Concatenate Dimensions

  • 25 January 2021
  • 1 reply
  • 7018 views

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


This topic has been closed for comments

1 reply

Userlevel 7
Badge

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#string

 

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