# Split these datatypes into 'name' & 'RechtsInfo'

**URL:** <https://community.parabola.io/t/split-these-datatypes-into-name-rechtsinfo/1952>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [July 29, 2021, 12:58pm UTC](https://community.parabola.io/t/split-these-datatypes-into-name-rechtsinfo/1952 "2021-07-29T12:58:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Olivier\_Coolen](https://avatars.discourse-cdn.com/v4/letter/o/6de8d8/32.png) [@Olivier\_Coolen](https://community.parabola.io/u/Olivier_Coolen)\
**Post date:** [July 29, 2021, 12:58pm UTC](https://community.parabola.io/t/split-these-datatypes-into-name-rechtsinfo/1952/1 "2021-07-29T12:58:01Z")

</div>

Hi all,

Currently it looks like this:

 ![Parabola](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/19acb8947e2c5712409cf33991a5c3c7a1b8f91e.png)

You can see it says NAME = BOUWJAAR and RECHTSINFO = 1930.

However, these are currently all in the columns LINKSINFO as you can see.

And I’d like to have a separate column with NAME and then another column as well RECHTSINFO.

How do I do this in parabola?

Thanks all!

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [July 29, 2021, 3:45pm UTC](https://community.parabola.io/t/split-these-datatypes-into-name-rechtsinfo/1952/2 "2021-07-29T15:45:29Z")

</div>

Hi @Olivier_Coolen

Welcome to the Parabola community 👋

Try using the [Expand JSON](https://parabola.io/transform/expand-json) step after pulling in your data from ParseHub. That step will automatically parse the data in your `LinkseInfo`column into new columns and rows.

Your `name` and `RechtseInfo` keys from your JSON blob will become the column headers. The values associated with those keys will become cell values.

Hope that helps!

---

<div class="post-metadata">

**Author:** ![Olivier\_Coolen](https://avatars.discourse-cdn.com/v4/letter/o/6de8d8/32.png) [@Olivier\_Coolen](https://community.parabola.io/u/Olivier_Coolen)\
**Post date:** [July 29, 2021, 4:46pm UTC](https://community.parabola.io/t/split-these-datatypes-into-name-rechtsinfo/1952/3 "2021-07-29T16:46:35Z")

</div>

Awesome, thanks for the great help! 🙂
