Manipulating simple fields

As already said, transformations deal with the data flow. As data goes through the PDI steps of a Transformation, it is manipulated or transformed in different ways. You already experimented with some possibilities. In this section, you will learn in detail how to transform different data according to your needs.

Working with strings

For any string, there are many transformations that you can apply to it, for example:

• Extracting part of the string
• Removing leading spaces
• Converting to uppercase

PDI offers several ways to do this. It's also common to find more than one step that can be used for the same purpose. The following table summarizes the most common PDI steps used to operate...