Hi Guys,
Looking for a bit of guidance or steer on in this one if anyone can help.
I need to do something when a row with a specific value is updated on SQL on Prem. As I can't use the built in trigger for when a row is modified due to the limitations with using via the on-orem gateway i'm trying to work around this.
What I have to done is use a cmbination of schedule, and then transfrorm data with power query, delay and transform data again to get 2 sets of data to compare - but not so great so far.
The queries do return the right information but I am absolutely struggling with the flow steps to compare these two tables.
The ouputs are body/value and do contain all the column I need tocompare however every which way I try and check for changes I get stuck in endless apply to each loops.
The query returns approx 800 rows, the columns contain the primary key and column I need to compare, e.g key, date.
I need to get key 001 from the first query and check if the date is the same or different to key 001 on the second query and so one until I get through each row.
I can do this fine using two different datasources eg excel or sharepoint but can't seem to get this to work here.
Hoping someone can help with a suggestion or guidance.
Cheers
RC
------------------------------
Roisin Conlon
------------------------------