Json issue

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?





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