Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Compare files using IPA

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Nabil
Veteran Member
Posts: 61
Veteran Member
3/3/2017 3:01 PM

    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
    Veteran Member
    Posts: 510
    Veteran Member
    3/3/2017 4:10 PM
      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
      Veteran Member
      Posts: 61
      Veteran Member
      3/3/2017 5:44 PM
        Do you suggest doing that using the File Iterator node?
        JimY
        Veteran Member
        Posts: 510
        Veteran Member
        3/3/2017 5: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
          Advanced Member
          Posts: 29
          Advanced Member
          3/3/2017 6: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.