Icon

List and JSON Extraction

Unpack lists from csv Unpack lists from csv and add day of week Unpack JSON from csv Split on commaas listDataUngroupRename columnRemove square bracketsDataRename columnConvert to JSONExtract from JSONUngroupClean upUsed to generate appropriatenumber of rowsConvert dates to KNIMEdate formatNode 29Node 30Remove timezoneExtract day of week (number) and day of week (name)Node 33Add day of weekcolumnsCleanup columnsNode 36Rename columnRemove square bracketsSplit on commaas listDataUngroup Cell Splitter CSV Reader Ungroup Column Rename Regex Extractor CSV Reader Column Rename String to JSON JSON Path Ungroup Regex Extractor Date&TimeDifference String to Date&Time Create Date&TimeRange Table Rowto Variable Modify Time Zone Extract Date&TimeFields Chunk Loop Start Column Appender Column Filter Loop End Column Rename Regex Extractor Cell Splitter CSV Reader Ungroup Unpack lists from csv Unpack lists from csv and add day of week Unpack JSON from csv Split on commaas listDataUngroupRename columnRemove square bracketsDataRename columnConvert to JSONExtract from JSONUngroupClean upUsed to generate appropriatenumber of rowsConvert dates to KNIMEdate formatNode 29Node 30Remove timezoneExtract day of week (number) and day of week (name)Node 33Add day of weekcolumnsCleanup columnsNode 36Rename columnRemove square bracketsSplit on commaas listDataUngroupCell Splitter CSV Reader Ungroup Column Rename Regex Extractor CSV Reader Column Rename String to JSON JSON Path Ungroup Regex Extractor Date&TimeDifference String to Date&Time Create Date&TimeRange Table Rowto Variable Modify Time Zone Extract Date&TimeFields Chunk Loop Start Column Appender Column Filter Loop End Column Rename Regex Extractor Cell Splitter CSV Reader Ungroup

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: Loic
Created at: 2022-06-29
On NodePit since: 2022-07-29
Last update: 2024-04-28
Created with KNIME version: v4.6.0

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

Try NodePit Runner!