Page Comparison

Panel

PLEASE NOTE: This documentation applies to Pentaho 8.1 and earlier. For Pentaho 8.2 and later, see Add a Checksum on the Pentaho Enterprise Edition documentation site.

Description

This step calculates checksums for one or more fields in the input stream and adds this to the output as a new field.

Option	Description
Step name	Name of the step. *Note*: This name has to be unique in a single transformation.
Type	The type of checksum that needs to be calculated. These are the types that are available: CRC32 : 32-bit Cyclic Redundancy Check : http://en.wikipedia.org/wiki/Cyclic_redundancy_check ADLER 32 : Checksum algorithm by Mark Adler: http://en.wikipedia.org/wiki/Adler-32 MD5 : Message Digest algorithm 5 : http://en.wikipedia.org/wiki/MD5 SHA-1 : Secure Hash Algorithm 1 : http://en.wikipedia.org/wiki/SHA-1 SHA-256 : Secure Hash Algorithm 2 : http://en.wikipedia.org/wiki/SHA-256
Result Type	Some checksum types allow to set different result types: String, Hexadecimal and Binary
Result field	The name of the result field containing the checksum
Compatibility Mode	Check this to be compatible with transformations that were created with a PDI version before 4.2.0. Before 4.2.0 there have been issues with a wrong hexadecimal encoding when Result Type is set to Hexadecimal (see details in PDI-5190).
Fields used in the checksum	The names of the fields to include in the checksum calculation. Note: You can use the "Get Fields" button to insert all input fields from previous steps.

A simple CRC32 sample can be found in this folder of your Kettle distribution:

Code Block
samples/transformations/Add a checksum - Basic CRC32 example.ktr