How to Error out the data?

[Gaurav0001]

Hi All,
I need help on how to error out the data and show which records/field is having an error in message.
I have found the way where we can use Message Tool if the condition is True, and it will error out.
But I need which row or column having an error.

For Example:

Name	Amount
ABC	100
BCD	50
CDE	110

In this I have written the Expression as : Amount > 100
So with this Expression I will get the Error message because Name : CDE having Amount 110.
But I want to see which row matches that condition as an Error Message or in Alteryx App Output Screen.

Your Help for this scenario will be appreciated.
Thank You.

[rzdodson · Accepted solution]

@Gaurav0001 here is one solution for you.

[Gaurav0001]

Hello @rzdodson ,
It will be great if you can please re share the workflow.
Thank You.

[rzdodson]

@Gaurav0001 updated the file from above. Should be good to go now.

[Gaurav0001]

Hi @rzdodson 
I have tried to use as your expression, But I am not sure why its giving me an error.
I have attached the error snap below for your reference, If you have any idea on this, Please help me to fix this.

[Gaurav0001]

Hey @rzdodson 
I have fixed my error,
As the Data Type should be in String to concatenate.

Thank You for your help. 😁