Icon

JKISeason4-15_​berti093

Download the JSON and the csvs from HUB

Authenticateto KNIME Hub
KNIME Hub Authenticator
Date UTC toofficial date
String to Date&Time
Connect toJKI space
Space Connector
Load payload_Details
CSV Reader
Loadrocket_Details
CSV Reader
Load launches
JSON Reader
Get the smallimages
Image Reader (Table)
Extract the year
Date&Time Part Extractor
Extractthe relevantcolumn
JSON Path
Just successfullandings
Row Filter
Visualization
Extractthe flights
JSON Path
Sum up
GroupBy
Flight JSONsto rows
Ungroup
Just the explorer XI
Row Filter
If missing==> false
Missing Value
Get theflight name
Joiner
Join by payloadID (left join)
Joiner

Nodes

Extensions

Links