I have a single excel file wherein I have to compare each cell data row by row whether they match or not and update the status to match

Help Studio
, ,
1

Refer the below data from excel file.

For ex: you can see that the num column and description column has some same data so i want to compare such data and update the status

Num Desc

11 RIO ABDI PRATAMA
12 SITI ZULAIHA
13 INDRAYANI
14 YAYAT SUPRIATNA
15 RINA AUSTRINA
15 RUDI PURWANTO
11 RIO ABDI PRATAMA
11 RIO ABDI PRATAMA
11 RIO ABDI PRATAMA
11 RIO ABDI PRATAMA
11 RIO ABDI PRATAMA

2

Hi @Vaishnavi_Ingole2

Can you share the expected output and conditions too.

Regards

3

Compare to what? Something like this?
image

4

@Vaishnavi_Ingole2

  • Excel Application Scope

    • Read Range (Output: dtExcelData) // Read data into DataTable

  • For Each Row (ForEachRow activity)

    • Assign Activity

      • left: cellData1 = row(“Column1”).ToString() // Get data from the first column
      • right: cellData2 = row(“Column2”).ToString() // Get data from the second column

    • If Activity

      • Condition: cellData1 = cellData2
        • Assign Activity: row(“Status”) = “Match”
      • Else
        • Assign Activity: row(“Status”) = “Not Match”

  • add data row activity update status

  • Write Range (Output: dtExcelData) // Write the updated DataTable back to Excel

5

Yes, I have to check whether the Num data and Desc data is same

for ex: in num column A7 has value 11 and A8 also has value 11 so the num value is same, same is with the desc, B7 & B8 Desc data is same, so now update status in status column as matched