PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/03/2017 1:53 PM by  SWilkins
Compare files using IPA
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Nabil
Programmer/Analyst
St. Luke's Health System
Veteran Member
(132 points)
Veteran Member
Posts:60


Send Message:

--
03/03/2017 10:01 AM

    Hello

     

    Is there any way to compare two dumps of the HRSUPER table? I'm creating a flow that modifies the Manager access and need to compare today's output to yesterdays for any changes. 

     

    Thank you,

    Nabil

    JimY
    Private
    Private
    Veteran Member
    (1191 points)
    Veteran Member
    Posts:427


    Send Message:

    --
    03/03/2017 11:10 AM
    How are you storing the dump's? I would think you could store yesterdays dump in a Sql Table and then have your flow read that table sequentially then use that to build the key to read the current table. You could then compare the values. You could also store yesterday's data in a comma delimited file and read it.
    Nabil
    Programmer/Analyst
    St. Luke's Health System
    Veteran Member
    (132 points)
    Veteran Member
    Posts:60


    Send Message:

    --
    03/03/2017 12:44 PM
    Do you suggest doing that using the File Iterator node?
    JimY
    Private
    Private
    Veteran Member
    (1191 points)
    Veteran Member
    Posts:427


    Send Message:

    --
    03/03/2017 12:57 PM
    Yes, if your previous days file is delimited. You could use the dataIterator node to read that and then place your Sql query node inside of the loop.
    SWilkins
    Admin Systems Architect
    Phoenix Children's Hospital
    Basic Member
    (45 points)
    Basic Member
    Posts:17


    Send Message:

    --
    03/03/2017 1:53 PM
    We do something similar in that we have an additional database with copies of a few production tables. Once a day IPA runs a SQL query to compare the tables in production and the alternate database. If differences are noted an email is sent and the copy table is refreshed with then current production data.
    You are not authorized to post a reply.