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

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

Datasets

Error Message

Data Investigation

Database Connection

Accepted answers

All comments

afv2688

Hello @PiyushJain ,

I have prepared something that might solve the issue.

Hope it helps

regards

filter values.yxmd

PiyushJain

Thanks afv2688,

It is working for message tool.

But my workflow required connection with block until tool then message tool.

Because the output of message tool again i will use via. Block until tool ,to get the final output..

Hope i am able to explain properly. Please let me know if additional information required.

I tried to connect block until tool with the workflow that you provide.

But could not able to understand how to proceed..

Please advise..

afv2688

Hello @PiyushJain ,

I am sorry I don't know if I am getting it right, you want to get the results saved in an output tool and then afterwards check if what is saved has the correct relationship with what you expect from the mesage tool?

I am having trouble with your expected result.

Regards

PiyushJain

Hi,

Thanks for your reply.

Soory if i am not able to explain my issue properly.

Ignore the word "output tool"

Let me try to explain again,

As per my understanding

Block until done tool works order wise

Like step 1 finish then step 2 start.....so on.

So in Block until done tool..

In 1st step an error message tool is connected with1 browse tool to store the output.

Now as per the " Block untill done" tool properties.

Once the 1st step run successfully, then only 2nd step will run ,so if Flag is N for 1st step.. then it should stop at that point and gave zero result and then order wise when step 2 comes in picture.it will also provide zero result.

That is my requirement..

Please advise.

afv2688

Hello @PiyushJain ,

Block until done is a tool designer mainly for saving files and avoid issues. Lets say for example you want to write two sheets on an excel file. With the block until done, it would first write on one sheet then the next one avoiding that way problems during the load of data to the file.

It can be used of course in many other cases but given here as far as I understand that you want to check firs if there is some "N" data on a specific column or not and if it is to pass no data to the end, my first proposed solution should suffice.

If you change on my example the results to be all "Y" you will see that the data goes through, if not, no data will continue passing by.

Regards

MarqueeCrew

@PiyushJain & @afv2688 ,

here's my hack for only outpouring if everything is without error. I use a combination of: summarize, append and filter.

summarize your N values and get a count of them. To be safe, create a text input where value = N and count = 0. Union that data and sort by count descending. Sample 1 records by grouping value. Filter to value = N

you will either get N|0 or N|1+

append the count back to your data. This will prevent our block the data until all values were counted. Now you can filter on count = 0. Good data, all of it will be true. If 1 record is bad, then everything goes false.

use a select tool to get rid of your count Field and you're ready for an Output tool.

cheers,

mark

PiyushJain

Thanks for the clarification.

But if i go ahead with 1st proposed solution,,help me to understand, how can used the output ( that is flag N with no records) to my next subsequent workflow ( as an input ) so that my next step understand the logic and falis or stop automatically.

Ideally i need to automate this process..

MarqueeCrew

You can still use an error message and stop the workflows before the append of count > 0. Use a CReW conditional runner is a way of automating.

chaosreignswithin.com

cheers,

mark

ChrisTX

Are you trying to stop running the workflow if Flag = N?

Could you use the first 4 tools in the workflow from @afv2688 and use the workflow runtime flag for Cancel Running Workflow on Error?

Chris

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

filter values.yxmd

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".