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.