[resolved] Query not executed for the indicator..Query is Null

Highlighted
One Star

[resolved] Query not executed for the indicator..Query is Null

Hi,
I am facing problem while creating new regex pattern for match analysis. I always get 
"Query not executed for the indicator.. Query is Null" response. Whereas when i use the existing regex from exchange, this doesn't come.
Can someone help me resolve this problem?
Regards,
Sivasankaran P
One Star

Re: [resolved] Query not executed for the indicator..Query is Null

Hello Siva,
Are you using tPatternCheck component in your job ?
With that component, you can use existing regex (for address, email, etc..) but also create your own regex. For that, you have to check "Personalized model" and put your own expression.

Devy
One Star

Re: [resolved] Query not executed for the indicator..Query is Null

Hi Devy,
Thanks for your response. Below is the error message I have received and the regex I used was also listed below.
'^(sales|info|enquiry)+@[a-zA-Z0-9]+\.[a-zA-Z]{2,4}$'
DB = MS SQL
I used the pattern test view to check my regex. It worked there, but when I applied that regex to an analysis. I got the below error message.
Employee

Re: [resolved] Query not executed for the indicator..Query is Null

SQL Server does not support regular expressions by default. (see https://help.talend.com/search/all?query=Regular+expressions+on+SQL+Server )
Either you need to install a UDF on your SQL Server, then adapt the indicator definition.
Or much simpler: you can select the java engine (in the analysis settings)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read