loading JSON file without flatten

tamermh
tamermh Registered Posts: 3 ✭✭✭✭
edited July 16 in Using Dataiku

Hi,

How can i load JSON file without flatten it ?

for example, similar to load json in pandas with

pd.read_json('datasets/empire_invoke_wmi_2019-05-18214442.json', lines=True)

i want to get the same results as in this screenshot

miro.medium.com/max/1400/1*_El_HrFmIjb4LU4jVzAEKA.png

Thanks

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker

    Hi,

    If your JSON file is made of one record per line, you could use the "One record per line" file format and then use the "flatten object" in the prepare recipe that does not recurse.

    We will be adding a flattening depth limit in the JSON format in DSS 8.0, sometimes this summer.

  • tamermh
    tamermh Registered Posts: 3 ✭✭✭✭

    Great, found it.

    Thanks alot

Setup Info
    Tags
      Help me…