# Expand JSON Not working

**URL:** <https://community.parabola.io/t/expand-json-not-working/1419>\
**Category:** Ask a question\
**Created:** [December 22, 2020, 2:41am UTC](https://community.parabola.io/t/expand-json-not-working/1419 "2020-12-22T02:41:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kashif\_Haque](https://avatars.discourse-cdn.com/v4/letter/k/b5e925/32.png) [@Kashif\_Haque](https://community.parabola.io/u/Kashif_Haque)\
**Post date:** [December 22, 2020, 2:41am UTC](https://community.parabola.io/t/expand-json-not-working/1419/1 "2020-12-22T02:41:06Z")

</div>

Hi guys,

I’ve got a JSON column that contains keys (name) and labels (values) that I want to turn into columns with appropriate values in place.

How do I go on about doing this, any help?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/d/dba109c3587d863d8168e66f112737c01b01fc49.png)

So, from the image, I want to have columns called : Greeting Card Options, e-Card Recipient Details, etc.

Many thanks!

---

<div class="post-metadata">

**Author:** ![anon36387498](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@anon36387498](https://community.parabola.io/u/anon36387498)\
**Post date:** [December 22, 2020, 7:56pm UTC](https://community.parabola.io/t/expand-json-not-working/1419/2 "2020-12-22T19:56:40Z")

</div>

Hello @Kashif_Haque! Glad we discussed this and resolved it internally by chat earlier, though I wanted to close the loop on this thread in case others encounter it.

Currently if a JSON column has spaces in its name, like `"Order: Discount Codes"`, then our updated step **Expand JSON** won’t auto-expand it. While our engineers work on this, please use the step **Rename columns** to remove spaces in a column’s name for **Expand JSON** to auto-expand it (like changing its name to `"Order:Discount.Codes"`).

 ![Rename-Expand](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/d/d5e335ad369023d6fcc2dfa3a2f015a919cfc35c.jpeg)

We’ll be sure to follow up on this thread once it is fixed. Should be before end of day tomorrow (Dec. 23rd). 🙂

---

<div class="post-metadata">

**Author:** ![anon36387498](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@anon36387498](https://community.parabola.io/u/anon36387498)\
**Post date:** [December 23, 2020, 11:09pm UTC](https://community.parabola.io/t/expand-json-not-working/1419/3 "2020-12-23T23:09:55Z")

</div>

Update: the **Expand JSON** step is back to auto-expanding JSON columns with (or without) spaces in their names! ✔

 ![Expand_JSON](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/c/c5eaf732e6744d113256d7c96995a5dd8ed0ada5.jpeg)