Connecting multiple strings as a new measure

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!

Solved Solved
0 1 821
1 ACCEPTED SOLUTION

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

I answered my own question!

View solution in original post

1 REPLY 1

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

I answered my own question!

Top Labels in this Space
Top Solution Authors