Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Message Tool - Pull data from column and add to message

hemant86
10 - Fireball

Hi Team,

 

I have data in below format. I am doing a validation for Input Amount and Recovered Amount and look for variances. I want to use the Message tool to alert the user for Variances and also include the respective EMP ID in the message. So according to the below case the message should read as "Recovery Variances found for EMP ID 1234468,1234469". Is there a way to do this. Appreciate any help.  

 

EMP IDInput AmountRecovered Amount(active)
123446610001000
123446720002000
123446830002000
123446940003000
5 REPLIES 5
DataNath
16 - Nebula

How's this @hemant86? I've just set this up as a single message at the end, in the warning (orange) colour, but you can change that depending on the requirement within the Message tool configuration:

 

DataNath_0-1660147557926.png

alberto_hernie
9 - Comet

hi @hemant86,

 

you can do the validation with formula tool and a boolean, please see below.

 

alberto_hernie_0-1660147535870.png

 

Then connect the message tool with below configuration and define the error message text. Change the message type if you want it to be a warning or error instead or normal log message

 

alberto_hernie_1-1660147570546.png

 

Result.

 

alberto_hernie_2-1660147616099.png

 

 

Regards,

Alberto

hemant86
10 - Fireball

Thanks @alberto_hernie . This is working but I see when I change Message Type to "Error - and Stop passing records" it only show one message with 1 ID

hemant86_0-1660150320946.pnghemant86_1-1660150343743.png

 

hemant86
10 - Fireball

Thanks @DataNath . This works great.😊. Always appreciate your help 

alberto_hernie
9 - Comet

@hemant86 to get the error message for each element failing in the validation please select the 'Error' mode instead of 'Error - And Stop Passing Records Through this Tool'

 

Regards,

Alberto

Labels