You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-10-17 10:56:49

DL001
Member
49 posts

DL001 said:

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

Offline

#2 2016-11-02 09:57:13

xdshi
Talend Team


xdshi said:

Re: What type of analysis is this?

Hi,
Are you looking for table analyses in Talend Data quality product?
https://help.talend.com/display/TalendO … e+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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-11-03 08:30:21

DL001
Member
49 posts

DL001 said:

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/display/TalendO … e+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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy