Google Big Query JSON j,v. objects into name/value pairs

Welcome to the community @Nigel_Godfrey!

Thanks a lot for providing link and function. That made it very simple. Here is an example workflow:

The output will then be like this:
Screenshot from 2021-01-14 09-29-19

2 Likes