How to match two columns in one sheet

[Sweety_Nagar]

Hi,
when i run robot i have to match two columns in excel at run time
for ex : columns name
NAME CITY SEARC NAME
ABC XYZ ABC MATCH
PQR TYZ DEF NOT MATCH NAME
RST MNP RST MATCH
Should be such a WRITE in excel
how can do this?

[lakshman (Ganta lakshman)]

@Sweety_Nagar

Try below steps.

1. Use Excel Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.

2. And then use For Each Row to iterate one by one row from DataTable.

   For Each currentRow in dtInput
       If currentRow("NAME").ToString.Trim.Equals(currentRow("SEARCH").ToString.Trim)
       Then 
          currentRow("ColumnName") = "MATCH"
        else
           currentRow("ColumnName") = "Not MATCH"
   

3. Finally use Write Range activity and pass DataTable dtInput to write into the excel file.