Hello friends, I am developing a workflow in which I have to check if a certain variable called Ag belongs to this table, in the column “Agenzia”: Agenzie Monitorate.xlsx (17.0 KB) [image] **How is it possible to check if a number is present in a column inside an Excel file (Column Agenzia of t…

Hi, Hope the below attached helps you! Check_ValueExist.zip (14.2 KB)

Hi @CamiCat I am attaching a worklow: Make the changes as per yout criteria…i.e. assign variable to ag and change the path of excel application scope. I hope it’ll work :slight_smile: Agenzia.xaml (8.1 KB)

Thank you so much @Sarath and @Niket_Ghai . Your workflows work, but I should insert this check inside a Decision Tree so It would be better to save the column in a Ienumerable variable and check if the string I want to search is in this column. Is it possible to do that? Thank you so much, +Cam…

@Sarath your answer was first so I pointed the solution to you :slight_smile: @Niket_Ghai yours works perfectly fine as well, but we can only mark as a Solution one answer per topic :slight_smile:

Thank you so much @ovi . Unfortunately this solution doesn’t work for my case. Is it possible to save the column in a Ienumerable variable and check if the string I want to search is in this column.? Thank you so much friends, Camilla

Does this help? [image] Comparing two data tables Help Hi Ananthu, You can use the DataTable.Rows.Contains method to check if the table already contains a row with same data. The check is done comparing the values in the columns set as Primary Key. So, first we need to se…

hi Ovi, i don’t understand dataColumn is ambergu

Check if two strings are equal

Help

ovi (Viorela Preda) June 26, 2018, 4:16pm 7

Does this help?

Topic		Replies	Views
Check if a value exists in particular column Help datatable , excel , activities	21	13731	October 15, 2020
How to check sub-string of the String is present in data table or not? Studio datatable , activities , studio , question	10	3399	September 24, 2021
Check value is available or not in excel column Help activities , studio	4	2422	May 14, 2019
Check whether a particular number is present in Data table Help	15	3915	June 16, 2019
How to search for specific string without using column name in whole excel sheet Help	5	2512	February 20, 2018

Check if two strings are equal

Related topics