Hello i am working with directory input to get me all excel files from a location and then using a batch input tool to get a specific tab's data. now same excel files are left open by a user, in my Results window i get an error message (see Image below)
i need to output the error message .
i have Tried using the Control container but it only runs off AMP engine and that interferes with my Batch input tool witch it cannot run off AMP engine, i am using the Alteryx 2023 version.
can anyone help me with this please?
Solved! Go to Solution.
hi! @Wvictoria428
try the solution from this post:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Creating-Error-Log-for-Export/...
hope this helps!
is there a way to export it on a excel not to be send to my email?
Try this one ( a friend suggested this):
Use the "Message" Tool
Alteryx provides a Message tool to capture specific messages, warnings, and errors that occur during the execution of a workflow.
Steps:
1. Add the "Message" Tool to your workflow:
The Message Tool can be found in the "Developer" tab in Alteryx.
2. Configure the Message Tool:
You can use this tool to display messages (informational, warnings, or errors) within your workflow.
Set the Message Type to "Error", "Warning", or "Information" depending on your need.
Example:
To output an error, you can use the message tool to display a custom message during the workflow.
3. Log Output:
You can configure the tool to write the messages to a file or log for further analysis.
Thank you
Welcome 😁!