Datatable Contains a Value Rather than X

Hi,
I have a datatable that I want to check. I put the actions in a do while however I need help for the condition part. How can I write a condition if the data table contains a value rather than for example x?

Thanks,
Aysegul

1 Like

Hi buddy @aysyavuz
–use a excel application scope and pass the file path of the excel
–use a read range activity and get the output with a variable of type datatable named outdt
–use for each row loop and pass the above variable as input
–inside this loop use a if condition like this
row(“columnname”).ToString.Contains(“x”)
if the condition passed it will go to THEN part where we can have any activity we want to proceed further
or
it will goto ELSE part

Cheers @aysyavuz

Use Vlookup Datatable activity