Json issue

[ace2131]

I am having a problem that also exists in other files.

As a sample file, I am looking to get values of, say, the name of the entity/business being repeated for all the reviews, but I am getting only reviews (from the child node) and entity info from the parent node is not being repeated. Can you help?

[JPollet]

Hello !
Difficult to answer directly with these complex data and I don’t realy understand the Columns to JSON in your workflow.
But I think that a way to achiev the goal is perhaps to extract first the JSON for the entity/business then extract the reviews (so two JSON Path) : this will keep the structure of data.
The JSON file seem to be an array of JSON, perhaps ungroup first could a solution.
Best,
Joel

[ace2131]

if i share the file, would that help?

[takbb]

Hi @ace2131 , from experience on the forum, I’d say it is always easier and faster for people to assist if you are able to share a sample data file, and also, if you have the sample workflow that you showed in the screenshot, and can upload that, then that’s even better because then people can assist with specifics and try things out without asking you as many questions, or having to guess at your config.

(But please ensure any sensitive information is removed or anonymized )

[ace2131]

Sample Data file attached.
sample.json (161.6 KB)

[takbb]

Hi @ace2131,

Please take a look at the attached workflow

json demo.knwf (404.8 KB)

Pulling parts of the json in stages, so initially collecting the “top level” structure consisting of each business with its reviews, then ungrouping and iteratively taking the next required “grouping” construct and ungrouping this, you can build rows that contain the business information along with each review.

[ace2131]

Thanks takbb, that works. Thanks a lot.