Icon

03 Flow Variables

Exercise for creating and using flow variables.

Filter data based on a previous result in a workflow.


Exercise: Flow VariablesRead the New York City Airbnb data by executing the CSV Reader node. Filter the data to the listings of the 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_id flow variable. How many rooms orapartments does this host id offer? In which neighborhood group are 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 of the 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_id flow variable. How many rooms orapartments does this host id offer? In which neighborhood group are 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

Nodes

Extensions

Links