Error and providing back files

Question

Hi,

I've built a workflow to run on the Alteryx server. What it does it to check some data quality and load the data into a SQL server.

However, if I find any errors in the data, I write these out to a 'log' file (excel) and use a comment tool to kill the process so that the data never makes it to the SQL server.

The bit that I'm getting stuck on is, how do I give the user back the log file, as on a successful run of the workflow it can be provided back, but is there no capability to provide this log file back if it errors?

JustinBabbitt · Accepted Answer

Hi @TimTim

There are a couple of ways you could handle creating output for the user.

One option is to have the user input a file directory (using a Text Input Tool) to the app, which will then be used to configure the output path. Then log will be written to whatever location is provided.

Another option is to always have it write out a log file that can either give a status of success or enumerate the errors present. This will require logic to ensure that the file is written before the message tool ends the process.

I hope this is helpful.