Table to JSON sort order

[dr_snglr]

Hello,

I’m trying to create a bunch of JSON files and was hoping to use KNIMEs “table to JSON” node, it would save me a lot of extra work…

It basically works fine, except that the JSON is sorted by “ABC”, it doesn’t follow the order of the input table:

Technically, it’s not wrong, just very difficult to read.

Is there a way how to force the input column order?

Thanks in advance for a reply.

[ipazin]

Hello @dr_snglr,

not sure how your data in KNIME is structured but if in one column how about String to JSON node?

Br,
Ivan

[dr_snglr]

Thanks for the reply.

I found a workaround that kind of works. I can prefix my columns with a number and replace them in the JSON before exporting:

Not exactly proud of that solution, but if it works, it works…

[ipazin]

Hello @dr_snglr,

glad you found a way but still have a feeling you should use String to JSON node in case you have data in single cell.

Br,
Ivan