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

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

Developer Tools

Error Message

Output

Custom Tools

Dynamic Processing

Accepted answers

Jay-RDC

HYG.

New Workflow5.yxmd

All comments

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?

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 FilipR,

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703