Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

  1. In the Transformer page, locate the column to use as your source. From the column menu, select Create column from examples.
  2. In the Transform Builder, enter the new column name.
  3. In the following example, a new column called zip is being created from the Addresses column:

    D caption
    Selected column and first value is specified
  4. Double-click an empty cell in the Preview column to populate it with an example. In the above, the zip code from the first value has been entered into the Preview column: 92704-4321.

    Tip

    Tip: You can copy values from the source column and paste them into the Preview column.

  5. While many of the zip code values from other rows have been accurately populated, there are still some values that need fixing. In the following, you can see that one zip code was not properly extracted. Double-click in the Preview column for the third row and fix the value: 91935:

    D caption
    Populating multiple example rows improves the overall quality of transformation across all rows
  6. A quick scroll through the rest of the rows in the sample indicate that you have properly extracted the zip code values for all rows. 
  7. Click Add to Recipe.
  8. The new Zip column is added to the dataset.

...