Logging Update Insert If New Data

[Jon_ct]

Hi,

I'm using the alteryx gallery to take data from oracle and update tables in mssql.  In the workflow results it notes how many records were updated and how many were inserted. 

Is it possible to capture that data and send it to my sql database?  Ideally I'd like to have a table that gives me all of the update & insert data by day.  

Thanks,

Jon

[PhilippK]

Hi @Jon_ct ,

I created a mock-up solution for you:

Let me know whether you could apply this to your SQL database.

Best regards

Phil

 

[Jon_ct]

@PhilippK Thank you for creating a mock-up!  I'm going to try it out and let you know how it works.