# Transform JSON with JQ

**URL:** https://community.glideapps.com/t/transform-json-with-jq/56088
**Category:** Ask for Help
**Created:** [December 27, 2022, 3:25pm UTC](https://community.glideapps.com/t/transform-json-with-jq/56088 "2022-12-27T15:25:17Z")
**Posts on this page:** 1
**Showing post:** 14

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 28, 2022, 12:08am UTC](https://community.glideapps.com/t/transform-json-with-jq/56088/14 "2022-12-28T00:08:15Z")

</div>

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!!!

 ![Screen Shot 2022-12-27 at 7.03.18 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e4692d59aba11be551aef3aacd3de837a260a03.jpeg)

```auto
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… 😉

---

_[View the full topic](https://community.glideapps.com/t/transform-json-with-jq/56088)._