Extract string within a string then pivot on values

  • 10 October 2022
  • 0 replies


I have a column called ‘TAGs’ with the below string for a row in question:




However I am trying to create a custom dimension to pivot on the ‘Looker_Type’ value (after the colon).

In the above string the Looker_Type (shown in Red) shows ‘Local’, but there can be up to 6 different words instead of ‘Local’, all with different character length

I'm really struggling to extract the string then pivot on it. I tried following similar steps on the below article, but I just can’t seem to get it to work: 

Id really appreciate someone’s help here.


Many thanks

This topic has been closed for comments