Icon

BLOB_​PARSE

As background....This BLOB comes from a GET call wherethe output is csv format in the return body. The expected number of rows is verylarge. In this case ~470K rows and willget larger over time.I've included a 50K sample to play with.This does work but the first transposestep takes quite a long time to complete. Makes me thing there is a more optimalway to handle this.I'm wondering if there is a more efficentway to get the same end result.Thanks!Jason Node 1280Node 1284Node 1285Node 1286Node 1287Node 1288Node 1289Node 1295Node 1296 Binary Objectsto Strings Cell Splitter Transpose Cell Splitter Insert ColumnHeader Row Splitter Transpose Column Rename(Regex) Table Reader As background....This BLOB comes from a GET call wherethe output is csv format in the return body. The expected number of rows is verylarge. In this case ~470K rows and willget larger over time.I've included a 50K sample to play with.This does work but the first transposestep takes quite a long time to complete. Makes me thing there is a more optimalway to handle this.I'm wondering if there is a more efficentway to get the same end result.Thanks!Jason Node 1280Node 1284Node 1285Node 1286Node 1287Node 1288Node 1289Node 1295Node 1296 Binary Objectsto Strings Cell Splitter Transpose Cell Splitter Insert ColumnHeader Row Splitter Transpose Column Rename(Regex) Table Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: jochoada
Created at: 2022-04-12
On NodePit since: 2022-04-13
Last update: 2024-11-21
Created with KNIME version: v4.5.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!