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 

[flying008]

Hi, @KrishnaChithrathil 

where are you want write warning message in Excel ? maybe other column if you can added.

[KrishnaChithrathil]

@flying008

Is it possible to add that warning message in the first cell A1? I don't need to write the entire output to that file. just that warning message. I hope my intension is clear. 

-Krishna

[grazitti_sapna]

Hey @KrishnaChithrathil 

With a message tool, you can customize a warning/error/message. 

[KrishnaChithrathil]

@grazitti_sapna

yes. that one is clear. But i'm asking if there's any way to write that "The field is null" message to an Excel file.

Any help?

[grazitti_sapna]

@KrishnaChithrathil, can you provide us with some sample input and the output that you are looking for?

Thanks!

[KrishnaChithrathil]

Hey, grazitti_sapna

Let's take the same example that you've provided in that screenshot. And the warning message you've provided in the message tool need to be written into an Excel. Is that possible?

[grazitti_sapna]

@KrishnaChithrathil, is this what you are trying to achieve?

Thanks!

[FilipR]

You can put NULL (just a string with a Formula tool) instead of blank spaces. Then you can filter the Excel file later to see where the NULLs are. You will not have pop up messages, though.

[KrishnaChithrathil]

Hey, grazitti_sapna

I'll try to make it clear. 

So we'll check the Field1 if there's any blank data or null value using formula tool.

If it finds, in this case, the second row, what I need is, a warning message to be given using the message tool and that same warning I need to save in an excel file.

So when I open the excel, the cell A1 should have that warning message, "This field is empty".

Since i'm new to Alteryx, i'm checking whether we can do this function or not.