• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 61
Veteran Member
3/3/2017 5:44 PM
Do you suggest doing that using the File Iterator node?
JimY
Veteran Member Send Private Message
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 Send Private Message
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.