Friday, June 1, 2012

Pentaho Kettle Text Padding Issue

Pentaho Kettle will pad text strings that come from the DB up till the size specified in the DB column (e.g. 100 in the case of varchar(100). Trim instructions don't work in getting rid of the padding. The important part is removing the length attribute when creating the output, or click the "Minimal Width" button where available.

No comments:

Post a Comment