topic Re: Logging Update Insert If New Data in Alteryx Server Discussions

Logging Update Insert If New Data

Jon_ct — Wed, 02 Dec 2020 17:37:10 GMT

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

Re: Logging Update Insert If New Data

PhilippK — Thu, 03 Dec 2020 11:35:57 GMT

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

Re: Logging Update Insert If New Data

Jon_ct — Thu, 03 Dec 2020 14:36:42 GMT

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