Mask bank code and account number and keep original country - 7.3

Data privacy

Version
7.3
Language
English (United States)
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Data privacy components
Data Quality and Preparation > Third-party systems > Data Quality components > Data privacy components
Design and Development > Third-party systems > Data Quality components > Data privacy components

This function masks IBAN and US bank account numbers. It keeps the original country. As the output depends on different criteria, it may not be a valid bank account number.

This function applies on String values.

Two methods are available: FF1 with AES and FF1 with SHA-2. This function requires no alphabet and no extra parameter.

An IBAN number is composed of several elements. Here is the terminology used for the data masking functions:
  • Black: Country code
  • Coral: Check digits
  • Light blue: Bank/branch code
  • Dark blue: Account number
  • Gray: National check digits. Their position in the IBAN number depends on the country.

    Some countries do not use national check digits.

Input account number

An input account number is considered as valid if:
  • The format is conform to the country code,
  • The check digits are valid and
  • The national check digits are valid. This applies to some bank account numbers, see the list. National check digits from other countries are not handled.

Logic of the function

If the input is... Then...
a valid IBAN number the function masks it by an IBAN number from the same country.
a valid US account number the function masks all digits.
Neither a valid IBAN nor US account number and there is: No "Invalid" output flow the function returns null in the main flow.
An "Invalid" output flow the input data are sent to the "Invalid" output flow.

Output account number

The output account number has the same characteristics as the input:
  • The format is conform to the country code,
  • The check digits are valid and
  • The national check digits are valid. This applies to some bank account numbers, see the list. National check digits from other countries are not handled.

As the bank/branch code is randomly generated, it may not be valid.

To verify whether the format of an IBAN number is valid or not, you can refer to this IBAN registry.

In the following example, the Keep format check box is selected to preserve the space from the input value.

Input value Method Example of masked value

SV43ACAT00000000000000123123

FF1 with SHA-2

SV94UDJR46506983550548404771

FR49 2867 2609 7580 N16P 4ZFM V39

FF1 with AES null

Cause: Invalid IBAN number

159 753 321 16 FF1 with SHA-2

538 646 897 36

4556156203746391 FF1 with AES null

Cause: Invalid bank account number

RO49 AAaA 1b31 1000 9344 0000 FF1 with SHA-2 null

Cause: Lowercase letters

IT21 Q054 2801 6000 0ABC D12Z E34

FF1 with SHA-2

IT38 B555 0814 456B B218 GN1U X4Z

ST23000200000289355710148

FF1 with AES

ST73378368332371018920239

To unmask the bank account numbers, use tDataUnmasking.

Important: For some countries, as the function behavior has been updated from the 7.3 R2020-11 monthly version, you can only unmask bank account numbers masked from this monthly version. See the list of the impacted countries.