From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

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.
Highlighted
Employee

Re: Problem with User Defined Indicators

Hi Madhu,
make sure you have choosen the appropriate indicator's category in the indicator editor.
Highlighted
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??
Highlighted
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?
Highlighted
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."
Highlighted
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%'
Highlighted
Employee

Re: Problem with User Defined Indicators

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

2019 GARTNER 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

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