Is there anyway we can write the warning message to an excel file?

[KrishnaChithrathil]

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 

[KrishnaChithrathil]

Hey FilipR,

Understood. But intension is to save the warning message in an excel file.

[Jay-RDC]

Try this. Also, not sure if you really need the message tool but hope this helps. 

[grazitti_sapna]

@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!

[KrishnaChithrathil]

Hey, @jayrdelacruz18

could you please share that workflow if possible?

[Jay-RDC · Accepted solution]

HYG.

[KrishnaChithrathil]

@jayrdelacruz18

In the excel file you're saving the entire column, right? Not possible to write only that message?

[Jay-RDC]

You can. Just use a filter tool after. So that only the field that has the message will pass through the data stream.

[KrishnaChithrathil]

@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?

[Jay-RDC]

Sure. Solution attached. 

[KrishnaChithrathil]

@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?