Solved

Connecting multiple strings as a new measure

  • 26 March 2021
  • 1 reply
  • 22 views

Hello!  I am wondering how to combine two strings (two different columns) into one new column

 

I am trying to combine a persons first_name and last_name to make a full_name new column.  This is the code I put into my project, but it doesn’t seem to work when I run queries on it.

 

 dimension: full_name {
    type: string
    sql: ${first_name} + " " + ${last_name} ;;
  }

 

Just curious as to how to do this!

icon

Best answer by nsmiy 26 March 2021, 17:37

  dimension: full_name {
    type: string
    sql: Concat(${first_name},' ', ${last_name}) ;;
  }

 

I answered my own question!

View original

1 reply

  dimension: full_name {
    type: string
    sql: Concat(${first_name},' ', ${last_name}) ;;
  }

 

I answered my own question!

Reply