Reading values in JSON collections

[gonhaddock]

Hello @wanglunberlin
You can check the following linked topic in KNIME forum, the provided solution may fit to your use case. Otherwise you can provide a sample data for a customized solution.

Not able to convert json to table

Hello @ravi13 I would try to extract the JSON with the following nodes sequence: ‘JSON Path’, then ‘Ungroup’ JSON sets. You can achieve the JSON Path configuration by selecting the table fields, and adding them with the ‘Add collection query’ option. The output will display your data group in sets. And finally Ungroup the JSON sets. [image] [image] BR

BR