Hello everyone,
I am new to Alteryx and I've been having trouble with this workflow for a while.If anyone can give me some suggestions on how can I make it work I will be appreciate it!
It has been working well so far when there is something to be fixed.
I am using Alteryx to process a xlsx file. It will process the sheet "NA", overwriting the sheet, renaming the file, and then send me a email with the status.
What I recently discovered is when there is nothing need to be fixed, the cell under the fruit(field) will showed nil(All I received before need to be modified).There is a field called effective date on the sheet,I will make comments based on that, so if I keep this route when there is nothing, it will cause a parse error(cause the datatype for that will be string not time).
Is there any way we can separate these two paths?
For example, if there is a nil under fruit, we can overwrite ,rename and send a email(saying there is no record in this file) without continue with the other path.
If there is something need to be fix,we make comments, overwrite ,rename and send a email(saying if there is any comment left blank).
I have attached a workflow with sample file(what it looks like when something needs to be fixed and there is nothing needs to be fix)
Hope it can help you understand it better and have a good one!
