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! Go to Solution.
dimension: full_name {
type: string
sql: Concat(${first_name},' ', ${last_name}) ;;
}
I answered my own question!
dimension: full_name {
type: string
sql: Concat(${first_name},' ', ${last_name}) ;;
}
I answered my own question!