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 |
Solved! Go to Solution.
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:
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
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
Thanks @DataNath . This works great.😊. Always appreciate your help
@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