I hope you can parse a Binary Large Object (BLOB) better than I can :)

KNIME Analytics Platform
2

Hi @j_ochoada,

I ran your workflow with a Timer node just to see what we’re working with.

As configured, your Cell Splitter node produces 61,821 columns, and the Transpose node converts this to 61,821 rows. The Cell Splitter took 1,460 ms and the Transpose node took 217,594 ms.

I compared this with my usual approach, which is to have the Cell Splitter node to output a list, then use an Ungroup node to get rows. The Cell Splitter node took 45 ms and the Ungroup node took 29 ms.

You can check it out here:

4 Likes