Writing log file to database

[cca8380]

I am looking for an example of a workflow that would write to contains of log file to a database. I am hoping to use this info for producing a Tableau report that would show the status/outcome of workflow execution.

Thanks in advance!!

[Felipe_Ribeir0 · Accepted solution]

Hi @cca8380 

Try this workflow: https://community.alteryx.com/t5/Community-Gallery/Parse-Alteryx-Log-Files/ta-p/999093

It is able to read the logs from your folder and parse them. You can just add a output to your database with the append method at the end of it.

It is interesting to mix this first workflow with this macro, so after reading the file, you can use the block until done and then move the file (from NewLogs folder to ProcessedLogs folder), so you will read each new file just 1 time: https://community.alteryx.com/t5/Community-Gallery/Move-files-between-folders/ta-p/998936