Mission 3 - First Data Manipulations

Estimated time for completing this mission: 15 mins

Learning Objective

In the previous task you successfully created your first logic. You have built a good foundation to start with more exciting missions. Therefore, create another logic for this task.

Scenario

The business_transactions dataset contains a column that needs to be split for proper processing. Your task is to split the "split_this_column" into separate Amount and Currency columns. The output table from this mission will be used in Mission 4, so ensure the transformation is completed correctly.

BLOX used in this mission:

• Basics/Start
• MyData/business_transaction.xlsx
• Database/Split
• Database/Rename
• Database/Delete Column
• Database/Update

Data

We will be using the same dataset as in the previous mission. (business_transaction.xlsx)

Steps

Please refer to the Navigation Guide to perform the steps below

1. In the Flow builder, drag-and-drop all the necessary BLOX listed above
2. Connect the BLOX components in the following sequence: Start → business_transaction → Split → Rename → Delete Column → Update

1. Configure the Split BLOX by clicking its settings. Set the column to split as "split_this_column" and specify the delimiter as a space
2. Configure the Rename BLOX. The Split BLOX outputs columns with numeric headers (0, 1, 2, ...). In our case, we get two columns named 0 and 1. In the Rename BLOX settings, enter Amount,Currency in the New Name input field. If columns don't appear properly, run the Flow and check again.
3. Configure the Delete Column BLOX by specifying split_this_column as the column to delete
4. Configure the Update BLOX by specifying the table name (use the same name as the dataset you're working with)

Results and Summary

Well done! Now let's move on to the next mission!