Problem with User Defined Indicators

Highlighted
One Star

Problem with User Defined Indicators

Hi -

I am Madhu new to Talend Open Profiler. I have created two simple "User Defined Indicators" to do counts. I have added them to a column analysis and has tested through "view executed query" and I am getting counts as per condition. But when I am trying to run the analysis in Analysis result I am not seeing any values under User Defined Count.

Will be great if somebody can help me.
Employee

Re: Problem with User Defined Indicators

Hi Madhu,
make sure you have choosen the appropriate indicator's category in the indicator editor.
One Star

Re: Problem with User Defined Indicators

Hi Scorreia - Thanks for reply.

This is the SQL Template I have used:

select count(*) from <%=__TABLE_NAME__%> where <%=__COLUMN_NAMES__%> like '%PO%'

Just to take count based on a simple condition.

For this I have selected "User Defined Count" as Indicator Category. is this correct or do I need to select something else??
Employee

Re: Problem with User Defined Indicators

That's correct. I just tried the same UDI with TOP 4.1.0 and I can see the chart.

Could you have a look in the Error view? Is there an exception?
One Star

Re: Problem with User Defined Indicators

Hi Scorreia

I could see an error message, which says as below:

"An exception stack trace is not available."
One Star

Re: Problem with User Defined Indicators

More details abt error:

2010-10-21 04:36:52,433 ERROR org.talend.dq.analysis.ColumnAnalysisSqlExecutor -

Query not executed for indicator: "PO" SQL query: SELECT COUNT(*) FROM "OM_CUST"."TEMP_PROFILING_IM" where "CCD_ADDRESS_LINE_1" like '%PO%'
Employee

Re: Problem with User Defined Indicators

I need the few lines before this message to understand the reason.

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