Add a Checksum

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

Add a Checksum step dialog

Options

Step name

Specify the unique name of the Add a Checksum step on the canvas. You can customize the name or leave it as the default.

Type

Specify the checksum type to calculate:

• CRC32 — 32-bit cyclic redundancy check

• ADLER 32 — Adler-32 checksum algorithm

• MD5 — Message Digest Algorithm 5

• SHA-1 — Secure Hash Algorithm 1

• SHA-256 — Secure Hash Algorithm 2

Result type

If you select MD5, SHA-1, or SHA-256 for Type, you can select one of these result types:

• String

• Hexadecimal

• Binary

Result field

Specify the name of the field that contains the checksum.

Compatibility Mode

Select this option to provide backward compatibility with transformations created before PDI version 4.2.0 and its hexadecimal encoding issue.

Old Checksum Behaviour Mode

If selected, incoming fields are treated as strings.

A binary field type produces the string representation of a byte array.

If cleared, all incoming fields are treated as byte arrays.

Field

In the table, specify which fields to include in the checksum calculation.

Get Fields

Select Get Fields to populate the fields table with fields derived from the input.

Example

Your Pentaho distribution includes a CRC32 sample transformation at:

design-tools/data-integration/samples/transformations/Add a checksum - Basic CRC32 example.ktr

Metadata injection support

All fields in this step support metadata injection. You can use this step with ETL metadata injection to pass metadata to your transformation at runtime.