to stop workflow when there is a duplicate in collumn a

[sands]

Hey all,

Im trying to figure out how to stop a workflow containing a table to stop when there is a duplicate in collumn a (yes, its the ID-collumn ). I saw already a lot of ways to stop the workflow when a table is empty yet that means that this table is different from the orginal table. The original table is not empty but might have some duplicates in the ID-collumn.
I did figure out the worflow in the screenshot but that just throws an message instead of stopping the workflow.

[MartinDDDD]

Hey there,

what behavior do you expect when you say “stop the workflow”.

Making the WF throw an error certainly is one way to achieve this :-).

In general I see two options to handle this “gracefully”:

1. add in Empty Table Switch to make the workflow finish but with a message that data was not processed because of duplicates
2. Use Breakpoint in combination with a try-catch block

I have prepared an example of 1) in the prototype below:

Overview:

Prototype:
stopWF.knwf (87.3 KB)

[sands]

Thanks Martin!

I cannot use it yet (ICT department decided to run version 5.2) but i will open it this evening at home and see how you accomplished this. Thanks again!