If switch / Case switch (if exists at least one row with a particular condition)
Hi friends,
I would like some help with if switch or Case switch.
Case
I have a workflow and I’m using a node to identified if there is a duplicated value in a particular column.
In this example, there is.
What I need:
How can I build a rule that validates the table and checks the following rule:
if in the “duplicate status” column there is at least one line with the word “chosen”, then do not move to the DB port, otherwise, move to the DB port.
My difficulty is identifying whether there is at least one line with the information. Because if it doesn’t exist, it means that all cases are “unique” and I can pass it to the DB, as it won’t give a “primary key” error in the database.
I created a simple workflow to help any friend who could help with this problem.
