Error when using regexextract on json string

Get Help
1

Hi everyone,

I want to extract values out of a json string using the regexextract command but seem to not put the right formula in. To my understanding I did the same as in the example metabase provides.
In the Image you can see the data I want to extract (Data column) and the formula I used (also tried variations of it).
The error messages doesnt make sense to me since I used the formula metabase provided.

image
image2117×1081 186 KB

Any help is appreciated

2

Hi @Cpt_Trips
Metabase does currently not support working with JSON/arrays:
https://github.com/metabase/metabase/issues/708 - upvote by clicking :+1: on the first post
You would have to expand your table in a view, so Metabase can read it.