Icon

03 Flow Variables - Solution

Solution to an exercise for creating and using flow variables.

Filter data based on a previous result in a workflow

CHECK YOUR ANSWERS:
The host id with the most listings offers 327 rooms/apartments located in Manhattan



Exercise: Flow VariablesRead the New York City Airbnb data by executing the CSV Reader node. Filter the data to the listings ofthe host with the most offers:1) Count the number of rows by host id2) Sort the aggregated data descending by the count of rows3) Transform the top row into a flow variable4) Use a Row Filter node to filter the original dataset. Overwrite the filtering pattern with the host_idflow variable. How many rooms or apartments does this host id offer? In which neighborhood groupare they located? Read AB_NYC_2019dataCount byhost idId with mostroomsFilter to therooms of the idwith most rooms CSV Reader GroupBy Sorter Row Filter Table Rowto Variable Exercise: Flow VariablesRead the New York City Airbnb data by executing the CSV Reader node. Filter the data to the listings ofthe host with the most offers:1) Count the number of rows by host id2) Sort the aggregated data descending by the count of rows3) Transform the top row into a flow variable4) Use a Row Filter node to filter the original dataset. Overwrite the filtering pattern with the host_idflow variable. How many rooms or apartments does this host id offer? In which neighborhood groupare they located? Read AB_NYC_2019dataCount byhost idId with mostroomsFilter to therooms of the idwith most roomsCSV Reader GroupBy Sorter Row Filter Table Rowto Variable

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: Maarit Laukkanen
Created at: 2020-10-26
On NodePit since: 2023-09-25
Last update: 2024-11-21
Created with KNIME version: v4.4.0
Tags: flow variabletable row to variable

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

Try NodePit Runner!