Check value is available or not in excel column

Help
,
1

Hi All,

image
I want to check that the for code 1 =456 , for code 2= 654 and Name = google is available or not.
please help me on this.

Regards,
naim

2

Hi @Naim,
Try using filter data table activity
image

Thanks,

1 Like
3

Hi @Naim,

First of all the steps are

  1. Load your Excel file to the Data Table by using Read Range activity.
  2. Iterate through every row of the Data Table by using For Each Row activity (the one under Programming->DataTable)
  3. Check your condition inside of the loop by using this line of code (when row is each item of the loop):
    row.Item("yourColumnName").ToString.Contains("yourKeyWord")
    This will return True or False, depending on whether the keyword is present in the particular column of the current row.

and for this case row.Item("Code 1").ToString.Contains("456") AND row.Item("Code 2").ToString.Contains("654") AND row.Item("Name").ToString.Contains("Google")

Hope this helps

Regards

1 Like
4

Hi @Naim

I have created workflow based on requirement run and let me know.

ExcelContainsData.zip (17.6 KB)

1 Like
5

Hi All Thanks for you response… I have received 3 reply all are working fine thanks

6

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