Hashing (CSV) block

The hash_csv_columns block hashes CSV data cell by cell using a specified hashing algorithm as a transformation block in a Connect+ dataflow. It applies one-way hashing to designated column headers in the source file, enabling data anonymisation or masking before the data is passed to downstream blocks.

When to use this block

Use this block when you need to anonymise or mask personally identifiable information (PII) — such as email addresses or mobile numbers — before the data is delivered to its destination.

Prerequisites

Before configuring this block, make sure you have:

  • Identified the column headers that contain data to be hashed
  • Selected the hashing algorithm appropriate for your security requirements

Configuration fields

Field nameRequiredDescription
Block nameNoA name for the block instance. The name must be alphanumeric. There is no character limit.
EnabledYesDetermines whether hashing is applied.
Select true or false from the dropdown.
Default value: false.
Hashing AlgorithmYesThe algorithm used to hash the CSV column data.
Select SHA-256, SHA-512, MD5, SHA-1, or RIPEMD-160 from the dropdown.
Default value: SHA-256.
HeadersToBeHashedYesThe column headers to be hashed, entered as a comma-separated list.
For example, email,mobile.
DelimiterYesThe delimiter used to separate fields in the CSV file. Default value: ,.