Error Message tool troubleshooting

[PiyushJain]

Hi Team,

Good Morning, 

Need your help to address below issue.

My requirement is : Do not pass any data if Flag is "N".

I am using "Block untill done" and "Message tool "together. 

Both tools are connected.like

Source-->>Block untill done-->>Message

So that the output of message tool ,i can again using  in block until tool and thus restrict the data feed ( if flag is N) .

 The  coloumn name " Flag" .

This coloumn having values like

Y 

N

In message tool i used below option:

Before rows where expressions  is True

And i am using below expression:

Flag = "N" And

Message Type is

"Error and Stop passing records through this tool"

NOW my expectation is that when i run the flow .. 

There will be no record in the output.

But i am geeting records those are having Flag = Y,

in message tool and getting no record in Output of block until done tools.Is this correct/ expected.

Or it there will be no record coming from both output. 

ideally i need to use the output of Block until tool.but if data coming in message tool output ,then this will impact my workflow running performance. 

Please advise .

Regards

Piyush

[afv2688]

Hello @PiyushJain ,

You can select on the runtime setting to cancel the run on error to stop the workflow if you want.

Regards

[PiyushJain]

Thanks Chris,

When i used solution workflow provided by @afv2688,

and if flag is N and with runtime option suggested by you,then workflow works as expected.

My question is when there is no N  only Y  ,then will this workflow run properly and i get all Y values. 

I mean will this automation work properly without manual  intervention?

I tested locally ( not scheduled) ,but need to double check and make sure everything will work as expected..

Please reply. And thanks both 

Regards

Piyush

[afv2688]

Hello @PiyushJain ,

Added just a few more tools just in case all the values that arrive are 'N'

Regards

[PiyushJain]

Many Thanks.

I will use similar set up and try to resolved the issue. 

[PiyushJain]

Hi Team,

Once again thanks for your help. I am able to fulful the requirement.

I tried to use similar setup in my other requirements and getting results but not sure whether my logic is correct or not.

My requirement is as below:

 I have 3 columns with values:

 Quarter : 2021 Q3

Flag: Y

Updated Date: This should be less than 10 days from today .. i mean 07th November'2021

So for next quarter 

If all the conditions matched,i mean Flag = Y ,Quarter = 2021 Q4 and Update date also match the condition, then only workflow run otherwise fails.

[

Also might be because i am using macros in my workflow ,i am not able to see runtime options ,so could not able to select option " cancel running workflow on error".

]

Coming to the workflow setup.

In summarize tool :

I used

count distinct for flag,

Countblank for Quarter, 

Max For updated date (but  not sure) 

After that in message tool, i used below expressions for each above 3 coloums.

[Flag]!= 1

[Countblank] >0

[ Max update date]:  not sure

Output is coming ,but seems logic is not correct.

Please advise.

Thanks