Pattern Frequency Statistics for DB2 in Qlik Talend Data Profiling

[wei_guo]

Unable to use data profiling to achieve Pattern Frequency Statistic on DB2. 

Resolution

As of R2025-06, the Pattern Frequency Statistic feature in Qlik Talend Studio > Data Profiling is not supported for DB2 databases. 

Workaround

Export the data in CSV format, define a file-delimited metadata type based on the CSV file, and then perform the profiling on that data.

For more information, see Pattern frequency statistics. 

An active Idea has been logged to support this feature for DB2. To vote on the idea, log in to Ideation before going to #495364 Talend Studio Data Profiling (DQ) support db2 Pattern Frequency Statistics indicators.

Environment

• Qlik Talend Studio