Assure DQ

 View Only

  • 1.  Comparing row counts between two files

    Employee
    Posted 07-22-2020 08:40

    I need to setup a control that compares only the row counts for two tables; one is a Hadoop table, and other a delimited file located in a folder on another server.

    I've successfully setup the Layouts that can connect to the table/file.  I'm now attempting to setup a control that will compare the row counts and report back if they match or not.  Any thoughts on this?  Seems easy but I'm stuck....Thanks!



  • 2.  RE: Comparing row counts between two files

    Employee
    Posted 07-22-2020 10:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    A common method for comparing row counts is using a tally: https://support.infogix.com/hc/en-us/articles/360052137213



  • 3.  RE: Comparing row counts between two files

    Employee
    Posted 07-22-2020 11:23

    Thanks Ryan--I'll check it out.