Padding transformation
A transformation type of Padding will transform data from the incoming file by adding padding to strings. You can use this transformation if the incoming string is shorter than the desired length. Set the desired length and padding character for the output string. The padding character is added to the beginning of strings.
To configure a padding transformation:
- Locate the data model attribute you want transformed and click its Transform link. The Transform dialog is displayed, and it shows the source fields (source) and schema attributes (target).
- Use the Transformation type list to select Padding.
- In the Desired string length field, enter the value that represents the minimum number of characters for strings. In the Padding character field, enter the character to use as padding so strings have the minimum number of characters. Only one character is allowed as the padding character.
- Optionally, test the transformation by entering a value in the Sample input field. The transformed value will display in the Output field.
- Click Apply.