Error Message Help

Question

I am creating an alteryx workflow and I am making sure the field names of 2 files are the same.

I need to have an error message display to the user if the filter tool (filtering True if the field names are the same for both files) returns false.

Is this possible?

echuong1 · Answer

If you're primarily concerned with the field names, you can use the Field Info tool. This will give you a list of the fields, data types, etc. within the dataset. From there, you can simply use a Join on the field name. Anything that is common between the two will come out of the J output. Anything exclusively in one of the files will come out of the L or R output.

New Workflow1.yxmd

AngelosPachis · Answer

Hi @andrewc22 ,

You can use a message tool to do that.

I have attached a count records tool to check if any records come out of the F output anchor of the filter tool. Then I have configured the message tool to error, if the value coming from the filter tool is greater than 0.

Hope that helps, let me know if that worked for you

Cheers,

Angelos

example.yxmd