How to verify if one variable exists in a Data Base?

[arthurfsantos11 (Arthur Santos)]

Hello my friends!

I need your help.

I’m working in a project that I have one Excel sheet that contains a codes list.

I need write a Condition in a IF COMMAND for that:

IF exists in a DATATABLE made one sequence.
IF not exist in a DATATABLE mode other sequence

Can u help me?

[loginerror (Maciej Kuźmicz)]

Hi @arthurfsantos11

Very easy method to check for that would be to output the Data Table to a string using Output Data Table activity and then to check if that output string contains your value, like that:
outputDataTable.Contains("yourValue")
This code will return a boolean true or false depending on your input

[arthurfsantos11 (Arthur Santos)]

Hello !

Thanks for help me!

You can attach one print about this command?

Thank you!