What type of analysis is this?

Highlighted
One Star

What type of analysis is this?

Hi
I have a parent table that has unique rows and a count of the children, e.g.
+---+--------+
| ID | Count  |
+---+--------+
| 1  |        0 |
+---+--------+
| 2  |        3 |
+---+--------+

and the child table has n rows per parent:

+---+------------+--------+
| ID | Parent ID  |   Attr   |
+---+------------+--------+
| 1  |             2 |           |
+---+------------+--------+
| 2  |             2 |           |
+---+------------+--------+

I need to analyse the tables to check that the number of rows in the child table matches the count stated in the parent.
What does Talend DQ call this analysis?
Thanks
Moderator

Re: What type of analysis is this?

Hi,
Are you looking for table analyses in Talend Data quality product?
https://help.talend.com/search/all?query=Table+analyses
Here is a DQ component TalendHelpCenter:tFuzzyMatch which compares a column from the main flow with a reference column from the lookup flow and outputs the main flow data displaying the distance.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: What type of analysis is this?

xdshi wrote:
Hi,
Are you looking for table analyses in Talend Data quality product?
https://help.talend.com/search/all?query=Table+analyses
Here is a DQ component TalendHelpCenter:tFuzzyMatch which compares a column from the main flow with a reference column from the lookup flow and outputs the main flow data displaying the distance.
Best regards
Sabrina

Yes, as stated originally, column analyses between tables.

It's not really a fuzzy match, thought, is it? I'm comparing the value in one table with a count in another. If I were writing this in SQL, it would be:

SELECT
  P.KeyColumn
, P.CountColumn
, CASE WHEN P.CountColumn = C1.RowCount
    THEN 'Y'
    ELSE 'N'
    END AS CountMatch
FROM ParentTable P
, (
  SELECT
      ParentKeyColumn
    , COUNT(1) AS RowCount
    FROM ChildTable
    GROUP BY
        ParentKeyColumn
  ) C1
WHERE P.KeyColumn = C1.ParentKeyColumn


Thanks

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

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