Transform JSON with JQ

Darren’s code will work, you just need to modify it a little, because you don’t have headers… Thanks, @Darren_Murphy !!! super fast and columns saver method… no need for templates, slicing, join columns, split columns, and single value columns… from JSON straight to split column… WOW… love it!!!

let json = JSON.parse(p1);
if (json[p2]) {
  return json[p2][0];
}

now I need to go back to my apps and change it LOL… that will cut off maybe another second from loading time… :wink:

1 Like