Show browse tool results with test tool in app?

I have configured my workflow to stop uploading output to a database if it finds any duplicates for the [Primary Key] column.

So, as designed, the test tool shows an error when it encounters the condition however the browse tool does not show any values.

I would like the output of the app to fail/not upload to the output tool if there are duplicates and still show the duplicates so that I can resolve these and then run the workflow again. however, the Interface Designer configuration allows to show the output only on success but nothing on failure.

There might be a better way to do this than using the Test tool.

How can I do it?

I have attached the example workflow.

Thanks HW

Example_Dupes.yxwz

Developer Tools

Reporting

Apps

Help

Optimization

Data Investigation

Accepted answers

All comments

TimN

Hi,

Try the message tool - seems to work

edit

@TimN The workflow does not show browse tool output when run as an app. It throws an error but no duplicated rows

TimN

What about a filter like this?

Message Type = Message

TimN

Here's the workflow. Hope it works!

Example_Dupes.yxwz

HW1

This is a brilliant idea however if there are no duplicates, this workflow does not carry though to the output node as the summary tool does not generate any rows. I will try to add the generate rows tool and an if-null-then-else in the formula tool to work around this tomorrow.

Thank you for the direction. 😄

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703