Concatenate Dimensions

  • 25 January 2021
  • 1 reply

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

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:


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