Hi,
How best can I check if a string is IN an array.
Lets say this is the dimension (array):
dimension: tags {
type: string
sql: ${TABLE}.tags ;;
}
This measure doesn’t work
measure: fund_count {
type: sum
sql:
CASE WHEN ${TABLE}.tags LIKE '%"Fund Fee"%'
THEN ${count}
END ;;
}
Thanks.
Solved! Go to Solution.
Found the answer:
I added JSON_SERIALIZE to the dimension array
dimension: tags {
type: string
sql: JSON_SERIALIZE(${TABLE}.tags) ;;
}
Found the answer:
I added JSON_SERIALIZE to the dimension array
dimension: tags {
type: string
sql: JSON_SERIALIZE(${TABLE}.tags) ;;
}