https://community.qlik.com/t5/Official-Support-Articles/Pattern-Frequency-Statistics-for-DB2-in-Qlik-Talend-Data/ta-p/2523190 <P>Unable to use data profiling to achieve <STRONG><FONT color="#339966">Pattern Frequency Statistic</FONT></STRONG> on DB2.&nbsp;</P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>As of <FONT color="#339966"><STRONG>R2025-06</STRONG></FONT>, the <FONT color="#339966"><STRONG>Pattern Frequency Statistic</STRONG></FONT> feature in <FONT color="#339966"><STRONG>Qlik Talend Studio</STRONG></FONT> &gt; <FONT color="#339966"><STRONG>Data Profiling</STRONG></FONT> is not supported for DB2 databases.&nbsp;</P> <H4><FONT color="#339966"><STRONG>Workaround</STRONG></FONT></H4> <P>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.</P> <P>For more information, see <A href="https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2025-06/pattern-frequency-statistics?ver=27" target="_blank" rel="noopener">Pattern frequency statistics</A>.&nbsp;</P> <P>An active Idea has been logged to support this feature for DB2. To vote on the idea, log in to <A href="https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight" target="_blank" rel="noopener">Ideation</A> before going to <A href="https://ideation.qlik.com/app/#/case/495364?currentProductId=9da99bc1-0dfb-4471-8e12-d23685578c43&amp;cpid=257de2f0-1b3f-4c26-aaeb-c2b58cd0f8a9" target="_blank" rel="noopener">#495364 Talend Studio Data Profiling (DQ) support db2 Pattern Frequency Statistics indicators</A>.</P> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <UL> <LI>Qlik Talend Studio</LI> </UL> Fri, 04 Jul 2025 11:10:32 GMT wei_guo 2025-07-04T11:10:32Z https://community.qlik.com/t5/Official-Support-Articles/Pattern-Frequency-Statistics-for-DB2-in-Qlik-Talend-Data/ta-p/2523190 <P>Unable to use data profiling to achieve <STRONG><FONT color="#339966">Pattern Frequency Statistic</FONT></STRONG> on DB2.&nbsp;</P> <H3><FONT color="#339966"><STRONG>Resolution</STRONG></FONT></H3> <P>As of <FONT color="#339966"><STRONG>R2025-06</STRONG></FONT>, the <FONT color="#339966"><STRONG>Pattern Frequency Statistic</STRONG></FONT> feature in <FONT color="#339966"><STRONG>Qlik Talend Studio</STRONG></FONT> &gt; <FONT color="#339966"><STRONG>Data Profiling</STRONG></FONT> is not supported for DB2 databases.&nbsp;</P> <H4><FONT color="#339966"><STRONG>Workaround</STRONG></FONT></H4> <P>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.</P> <P>For more information, see <A href="https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2025-06/pattern-frequency-statistics?ver=27" target="_blank" rel="noopener">Pattern frequency statistics</A>.&nbsp;</P> <P>An active Idea has been logged to support this feature for DB2. To vote on the idea, log in to <A href="https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight" target="_blank" rel="noopener">Ideation</A> before going to <A href="https://ideation.qlik.com/app/#/case/495364?currentProductId=9da99bc1-0dfb-4471-8e12-d23685578c43&amp;cpid=257de2f0-1b3f-4c26-aaeb-c2b58cd0f8a9" target="_blank" rel="noopener">#495364 Talend Studio Data Profiling (DQ) support db2 Pattern Frequency Statistics indicators</A>.</P> <P>&nbsp;</P> <H4><FONT color="#339966"><STRONG>Environment</STRONG></FONT></H4> <UL> <LI>Qlik Talend Studio</LI> </UL> Fri, 04 Jul 2025 11:10:32 GMT https://community.qlik.com/t5/Official-Support-Articles/Pattern-Frequency-Statistics-for-DB2-in-Qlik-Talend-Data/ta-p/2523190 wei_guo 2025-07-04T11:10:32Z