Icon

Extract JSON Values - KNIME Forum (90193)

<p>Extract JSON Values - KNIME Forum (90193)</p>

URL: Extract JSON Values - KNIME Forum (90193) https://forum.knime.com/t/json-missing-data-issue/90193/6?u=mlauber71
URL: NEW Approach: Loop thru the JSON sub-structures and extract them by chunk - KNIME Forum (90193) https://forum.knime.com/t/json-missing-data-issue/90193/11?u=mlauber71

Extract JSON Values - KNIME Forum (90193)

https://forum.knime.com/t/json-missing-data-issue/90193/6?u=mlauber71

Old approach that seems to have problems with ungroup

NEW Approach: Loop thru the JSON sub-structures and extract them by chunk - KNIME Forum (90193)

https://forum.knime.com/t/json-missing-data-issue/90193/11?u=mlauber71

Determine the number of chunks to handle

GroupBy
some fields are off ....
Column Filter
Table Row to Variable
Row_ID
RowID
tiger.games96rexzachofskyviralvid4youborda.plantabrian.c7003
Row Filter
Table Row to Variable
$[<n>]JSON3
JSON Path
$[1:]skip the first entry
JSON Path
json_patternreturn "$[" + $${IcurrentIteration}$$ + "]";
Java Edit Variable (simple)
JSON Reader
dataset_tiktok-scraper_2025-10-13_23-10-12-115.zip
Decompress Files
Column Filter
Counting Loop Start
keep lists
Column Filter
tiger.games96rexzachofskyviralvid4youborda.plantabrian.c7003
Row Filter
JSON2
JSON Path
extract sub-JSON
JSON Path
Ungroup
collect the resultsby ID / Chunk
Loop End
authorMeta
Column Filter
(.+)aut_$1
Column Name Replacer
authorMetahearts as Long
JSON Path
authorMetashearts as Long
JSON Path
videoMeta
Column Filter
result.table
Table Writer
(.+)vid_$1
Column Name Replacer
Joiner
videoMetas
JSON Path
videoMeta
JSON Path
JSON2
JSON Path
Row_ID
Constant Value Column
Ungroup
subtitleLinksssub_<..>
JSON Path
Joiner
result_selection.table
Table Writer
Column Filter

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: preriit
Created at: 2025-10-13
On NodePit since: 2025-10-15
Last update: 2025-11-04
Created with KNIME version: v5.7.0
Tags: JSONchunksub-chunk

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

Try NodePit Runner!