Say, I've a table with one column. And i'm checking if the fields are null or not. If any field is null, update that field with a default value and give a warning message that "This field is empty". or some thing else. And I need this message to be written to an excel file.
Any help would be highly appreciated.
- Krishna
Solved! Go to Solution.
Try this. Also, not sure if you really need the message tool but hope this helps.
@KrishnaChithrathil, even if you use a message tool it will only give you a warning in alteryx workflow log.
I am not sure if this can get exported in excel but there must be a log created. Please refer to this link if it helps- https://help.alteryx.com/20221/designer/output-log-file
Thanks!
@jayrdelacruz18
In the excel file you're saving the entire column, right? Not possible to write only that message?
You can. Just use a filter tool after. So that only the field that has the message will pass through the data stream.
@jayrdelacruz18
Understood. I hope we can specify which cell is being null or getting this warning message, while we write to the excel.
Is that possible anyhow?
@jayrdelacruz18
yes. this is also a good solution. Here, actually the message tool has no role. I was expecting that, there would be a way to directly save the message tool warning to excel. But that's not possible I guess.
Just for the clarification, we should use this piece of workflow repeatedly to check the same for other columns, right?