Hi Everyone, I’m working on 1 excel task like comparing 2 different data tables and i need to update missing data in another sheet.
The problem is i need to check 3 columns data if all matches then only i need to update matching data in another sheet.
i need to check these above columns if all are matches then i need to update Phone Number and Match count like how many matches are available.
Data1.xlsx (9.9 KB)
Data2.xlsx (9.3 KB)
I’m unable to solve this can anyone guide me how to do.
Try like this…
- Read range->FirstData1->Output As->Dt1
- Read range->Data2->Output As->Dt2
- Take one assign Activity create int variable like this
Counter = 1
Take 2 for each row in data table activities
- For each row pass the Dt1
inside the First For each row take second for each row pass the dt2
now take one IF Condition and pass the expression like this
CurrentRow1("Payment mode").ToString.Trim.Equals(CurrentRow2("Payment mode").ToString.trim) AND CurrentRow1("Payment").ToString.Trim.Equals(CurrentRow2("Payment").ToString.trim) AND CurrentRow1("Bank Name
In then Block Use Write cell activity
- Pass the FilePath
- Pass the sheetName
- CurrentRow2(“Phone Number”).ToString.Trim
- Range “E1:E”+(Counter.Tostring)+1
Take one assign activity and pass the expression like this
Counter = Counter+1
Do do anything in else part
Thanks for your solution @THIRU_NANI
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.