I have list of customer names in variable I have one excel contains few customer names in one column i wants to check that variable is prsent in excel or not if yes then i wants to remove that customer file from dictionary so for this what can i do (if condition)

@pravin_bindage read range and using each row in the data table if condition currentrow(“column”) is item Then add it to another data table by using add datarow activity

Compare string with excel column values

Help Activities

sangeethaneelavannan1 (Sangeetha Neelavannan) December 13, 2022, 8:51am 10

Currentrow(X).tostring.equal(currentrow(y).tostring)
Try this

Topic		Replies	Views
How to search if a data table contains a variable Studio excel	7	698	October 8, 2023
Problems in comparing values Help	8	1827	October 29, 2018
Check Value from excel Help	6	4912	May 18, 2019
Check Excel cell value & use If activity Studio datatable , excel , uiautomation , studio , question	11	3624	August 12, 2022
Extract a specific value from a data table with a variable Learning Hub	3	5928	April 1, 2020

Compare string with excel column values

Related topics