Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Replies posted by bharti.joseph

1 Reply

B
bharti.josephNew Member
asked in LookML

grouping number and string data types into one dimension

Thanks Lizzi I was able to successfully do this with below statement:CASE WHEN ${TABLE}.employees like "%-%" then CAST(SPLIT(${TABLE}.employees, "-")[SAFE_OFFSET(1)] AS INT64 )    WHEN ${TABLE}.employees like "%+" then CAST(SPLIT(${TABLE}.employees, "+")[SAFE_OFFSET(0)] AS INT64 )ELSE CAST(${TABLE}.employees  AS INT64 )END

2
B
10 months ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service