Message Tool - Pull data from column and add to message

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 ID	Input Amount	Recovered Amount(active)
1234466	1000	1000
1234467	2000	2000
1234468	3000	2000
1234469	4000	3000

Error Message

Accepted answers

DataNath

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:

Warning message for IDs with variance.yxmd

All comments

DataNath

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:

Warning message for IDs with variance.yxmd

alberto_herni

hi @hemant86,

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

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

Result.

Regards,

Alberto

hemant86

Thanks @alberto_herni . 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

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177