Mission 7 - Joint Tables
Estimated time for completing this mission: 15 mins
Learning Objective
Understanding how to perform SQL-like operations done purely in LOGIBLOX.
Scenario
Imagine you have two datasets where you have to map "Suppliers Names" to its "Suppliers IDs". Both datasets contain "Suppliers IDs" as the primary key.
BLOX used in this mission:
- Basics/Start
- MyData/lookup_suppliers
- MyData/business_transactions
- Database/Join
- Database/Save
Data
Please download the dataset, which will be used: business_transaction.xlsx and lookup_suppliers.xlsx. The first one is the same dataset you should have created in mission 3.
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 the "MyData" BLOX
- Now, connect both of the datasets BLOX outputs to the "Join" BLOX
- Finally, connect the output from "Join" BLOX to "Save" BLOX
- In the "Join" BLOX settings we have to specify the column containing the primary key ("Supplier_ID") and the type of join (in our case we need "left" type of join)
- In order to save the newly created dataset connect the "Join" to the "Save" BLOX and name the new dataset "data_with_suppliers" in the left side bar of "Save" BLOX and specify the folder "Module 2"
- Now, pressing the start button on "Start" BLOX will activate the logics chain and save the outcome under the name and folder specified in the "Save" BLOX.
Results and Summary
You can now easily perform all sorts of join operations with two tables. We will use the newly created dataset in next missions for further operations.
