Mission 4 - Filtering the Dataset
Estimated time for completing this mission: 15 mins
Learning Objective
Understanding how certain records can be filtered out from the dataset using BLOX.
Scenario
The business_transactions dataset contains invalid data entries with negative amounts. Your task is to filter out these invalid records and keep only transactions with positive values in the Amount column.
BLOX used in this mission:
- Basics/Start
- MyData/business_transaction
- Database/Update
Data
In this mission we will use the processed dataset from the previous section. If you didn’t create it in the previous mission, here is a link for the dataset: business_transactions.xlsx
Steps
Please refer to the Navigation Guide to perform the steps below
- In the Flow Builder, drag-and-drop all the necessary BLOX listed above
- Connect the "Start" BLOX to "MyData" BLOX
- Click on "MyData" BLOX and go to the column you want to filter (amount), by clicking on the first dropdown you can choose the operation ("Greater Equal" in our case) and the filter operand (0 in our case) in the second box. With this step, we filter out the invalid (in our case negative) data points
- Now we want to sort the data by the column "Amount". It is your task to implement that
Hint
In the "MyData" BLOX settings, find the "Sort By" input and specify "Amount" as the column to sort by!
- Next connect the output from "MyData" BLOX to "Update" BLOX, and specify the dataset to be updated (business_transactions.xlsx in our case)
- Now pressing the start button on "Start" BLOX will activate the logics chain and the outcome can be seen by double clicking on the "MyData" BLOX
Results and Summary
You can now easily perform all sorts of filtering operations on columns. Now you have created a modified dataset, which will be used some of the following sections.
