Compare string with data table

I have two strings one that is called “date” and another one “number” and I have a datatable that I read from an excel, what I want to do is search the datatable if those two strings already exist

this is my excel
image

and these are the variables that I want to see if they already exist

since depending on whether they exist or not I will do something specific

any idea how to do it?

Like this:

Processusvierge.zip (18,3 Ko)

}

I tried that but despite the fact that if they are the same, he sends me that none of them match

I think the problem is that the excel date brings it to me like this “dd / MM / yyy 00:00:00” how can I remove that timestamp

This is how the format brings me
image

I misunderstood the request. I thought you wanted to act on each match line by line. If you want to do something if 1 or more matches exist, and a different thing if no matches exist, here is how the workflow should be built.

Processusvierge.zip (18,5 Ko)

1 Like

It is correct I realized that my error is that in excel I put date format and I must put general format

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.