Reordering a preparation step - Cloud

Talend Cloud Data Preparation Getting Started Guide

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2024-03-05

In Talend Cloud Data Preparation, each preparation step you apply on your data is based on the previous one. As a consequence, if you already applied many preparation steps to your data, but forgot one small change at the beginning, you would not achieve the expected result.

In a preparation with many steps, you have the possibility to rearrange your preparation steps so that the changes take effect in the right order.

In the earlier steps, you have performed a lookup on the State column just before making a correction to this column, where the Texas entry was in the wrong format. Because that last change on the State column was performed after the lookup, some information is now missing from the Region column that was added with the lookup.

State and Region columns with an empty cell in the Region column.

You are going to take the lookup step and place it as the last step of the preparation to make sure it includes all the States.

Procedure

  1. Point your mouse over the lookup step.
  2. To move the lookup step from the second-last position to the last position, you can:
    • Either drag the recipe step and drop it at the bottom of your recipe.
      Recipe with the Lookup step being dragged and dropped.

      the grey line shows where the recipe will be placed.

    • Or click the down arrow on the left of your recipe step to move it down.
      Down arrow on the left of the recipe.

Results

Your preparation is automatically updated with the correct sequence of actions, and the Region column now includes Texas.
The Texas value appears in the column.