Know the Pattern Frequency Stats of your data using Taland Data Quality

Hi all,
I'm going to tell you how you can get data patterns using  Taland Data Quality tool.

We have a column named "nric_no" and we want to know the various data pattern of this column.

Sample data:

nric_no

761229-03-5225

641119-01-5411

A0869179

A0138399

A2900392

AA288814

A 1487544

So here are the steps to execute the pattern analysis using Talend DQ.

Step 1.

​

Step 2.

Select columns (nric_no)

​

Select indicators (Pattern frequency table)

​

Step 3.

 Click the Run button.

Output:



​