How do I retrieve values from a table to use in a conditional (if) statement?

Question

I have a bot that updates information in the database. I set a conditional statement to check if the entered ID is valid (if it exists in the database). If it is, it is executed, but if not, a message is displayed.

The problem is that regardless of the entered ID, the RPA runs, appearing as if the information was updated in the database.

I debugged it, and when I enter a valid ID that exists, the table variable returns a value of 1 in row 0. However, when I enter an ID that doesn't exist, it returns a value of zero (0) in row 0.
How can I use this information to validate, since the if statement doesn't have this option; the available options are: empty data table, number of columns, and number of rows?

Page 1 / 1

@cunhatr First, see how your table is defined. Since you have a number being returned, I am choosing the format mine as a number for this column.

Then use the Number condition in the IF statement.

This works the same way if the table column is a String or Boolean; just use String Condition or Boolean Condition in your IF.

Reply

Aaron.Gleason · Accepted Answer

​@cunhatrFirst, see how your table is defined. Since you have a number being returned, I am choosing the format mine as a number for this column.Then use the Number condition in the IF statement.This works the same way if the table column is a String or Boolean; just use String Condition or Boolean Condition in your IF.

Reply

Sign up

Login to the Pathfinder Community

Scanning file for viruses.

This file cannot be downloaded