I am facing converting below json file to table can anyone guide me with it.
Basically I have import data using json reader node and trying json to table node to convert it to table format, but i am failing at it .
can anyone guide it to me ?
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.