JSON file to excel

gshikha16 · March 2, 2021, 6:11am

Hello,

I have one JSON file containing millions of rows. I am not able to read file through JSON reader and also not able to convert that file into excel.
Any suggestion will be helpful.

Thanks in advance

rd2575691 · March 2, 2021, 10:51am

Hello,

If there is a general pattern, it can be converted. Have you tried it using R or Python within Knime or outside?

gshikha16 · March 2, 2021, 4:23pm

No i did not. i will try now.
Thanks for the suggestion.

ipazin · July 12, 2021, 1:35pm

Hello @gshikha16,

with KNIME version 4.4.0 JSON Reader has been improved (rewritten to comply with new file handling framework) and thus should be able to handle large files. Give it a try!

Br,
Ivan

system · January 11, 2022, 1:36am

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.