Mission 6 - Concatenate Tables
Estimated time for completing this mission: 15 mins
Learning Objective
Learning how to combine multiple tables into one.
Scenario
In this task, your are required to merge the four different lookup tables of different length into a new table and store it. The results will be stored in the "Table" BLOX; the result can be looked up by double clicking on it.
BLOX used in this mission:
- Basics/Start
- MyData/lookup1
- MyData/lookup2
- MyData/lookup3
- MyData/lookup4
- Database/Table
- Database/Save
Data
Please download the datasets, which will be used:
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 all “MyData” BLOX
- Now connect the outputs from datasets to the "Table" BLOX
- In order to save the newly created dataset connect the "Table" to the "Save" BLOX
- Choose which folder (Module 2 in our case) you would like to save to and the desired dataset name
Results and Summary
Thanks to these few simple steps you are now able to merge datasets and save the outcome in the folder of your choice
