User defined indicator question

Highlighted
Employee

User defined indicator question

Hi,

I have a master and a detail table. With data profiling I want to create an user defined indicator (based on frequency) to show the records in red with the following SQL:

select d.id,d.seq,d.valid_from,d.valid_to, max(seq) from fall_05_d d inner join fall_05_m m on m.id=d.id where d.valid_to='9999-12-31' and m.flag='Y' group by d.id

The indicator has the following syntax:
select d.<%=__COLUMN_NAMES__%>,MAX(d.`seq`)
FROM <%=__TABLE_NAME__%> d inner join d.`fall_05_m` m on m.ìd`= d.ìd` where where d.`valid_to`='9999-12-31' and m.`flag`='Y' GROUP BY d.<%=__COLUMN_NAMES__%>

The analysis does not work..what is wrong..perhaps someone can help..thanks


Mastertabelle
ID Valid From Valid To Flag
1003 01.01.2010 13.06.2011 N
1003 14.06.2011 31.12.9999 Y
1004 31.03.2011 31.12.9999 N
1005 01.01.2012 31.01.2012 N
1005 01.02.2012 31.12.9999 Y

Detailtabelle
ID Seq Valid From Valid To
1003 1 01.01.2010 01.06.2011
1003 1 02.06.2011 13.06.2011
1003 2 14.04.2010 31.12.9999
1003 3 31.03.2011 31.12.9999
1004 1 31.03.2011 31.12.9999
1005 1 01.01.2012 31.12.9999
1005 2 15.01.2012 31.01.2012
Employee

Re: User defined indicator question

Hi,

User defined indicators currently only work on a single column in column analysis.
Here, you seem to want to retrieve several columns.

If this indicator is to be used on a single table, then you could try
select d.<%=__COLUMN_NAMES__%> ,d.seq,d.valid_from,d.valid_to, max(seq) FROM <%=__TABLE_NAME__%> d inner join d.`fall_05_m` m on m.ìd`= d.ìd` where where d.`valid_to`='9999-12-31' and m.`flag`='Y' GROUP BY d.<%=__COLUMN_NAMES__%>
and apply this indicator on d.id.
Employee

Re: User defined indicator question

Hi,
i use the UDI in a single table analysis but the analysis comes back with an error. Which indicator category do you use?

The release I am using 5.02
One Star

Re: User defined indicator question

Hello, I do not speak English well... but I am going to try!
I prepare my project of the end of studies I work with TOS dated quality 5 in the first one on 2 tables of a database for the test (...) I have just defined a personal indicator which has for objective to show the empty recordings, that works except that when I make one clique straight ahead on the results to see empty lines that does not work , while with the predefined indicators that works

my question: what that is possible to make one clique straight ahead on the results to post show the values, if yes, please how to make it?

THANK YOU FOR HELPING ME.

MERYAM.

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