I am using XPath to parse through some XML data and have some data as collection cells that I need to convert into string cells in order to export into Excel. I have tried Split Collection Column and then Column Combine. However, some values are missing and return as a “?”, so my combined column includes a bunch of “?,?,?,?,?,?,?”. I’ve tried to simply remove these after using String Manipulation. However, I feel that this is not ideal, since I now have hundreds of columns that my collection cell has split into, most just returning “?”. I have also tried parsing the XML data into Multiple Columns instead of a collection cell, but the output would be the same as aforementioned. I have also tried Ungroup, but that just creates multiple duplicate rows, which I’m not sure I necessarily want either. Open to any solutions, so any ideas at all would be great.

This might also help you eventually: [image] Convert List to String KNIME Analytics Platform We have a Collection to String node unreleased at present at @vernalis . When back in the office I will see about getting out released. Steve Steve

Convert collection cell to string for exporting into Excel file?

KNIME Analytics Platform

s.roughley April 24, 2019, 9:16pm 3

This might also help you eventually:

Steve

4 Likes