03_XML_meets_JSON

Will they blend? XML meets JSON The challenge here is to blend together data in XML format with data in JSON format. We queried IBM Watson about news on Barack Obama and on Michelle Obama through a REST service API. Michelle Obama headlines are returned as JSON, while Barack Obama headlines are returned as XML. In this workflow the responses are read from an XML and a JSON file resp. Will they blend? ... and yes! They blend.


This is a companion discussion topic for the original entry at https://kni.me/w/9j6yuqGbBXKLqrwi

Hi RS,

can I use ungroup node to convert column to rows?
I have a table containing only one row, and 20 columns. I want to convert these columns to rows.

Many Thanks,
Rao

It depends on the format of your data, but I think what you may want here is the Transpose node.

Hi ScottF,

Thank you very much. I search this node many times in Node Repository, check spelling many times, but I was unable to find this node in my KNIME. When this node is published??

Many Thanks,
Rao

That’s strange. The Transpose node is part of the regular KNIME installation - no extension should be necessary. Can you drag and drop the node from the link to the Hub I provided above?

yah so strange, I just drag and drop, KNIME should developed online Analytical Platform, so no issue will be raised