Hi, how to check if “Person number” in Excel 1 is Exist on Excel 2(“Person Number”) if Not Exist write remarks “Failed” on excel 1 if Exist Just Skip the record. [image] Kind Regards Vincent

Hey @Vincent_Nuestro Appreciate you tried. :+1: [image] Here is a workflow, this should help. ToCheck.zip (14.8 KB)

Check if Record from Excel 1 is Exist on Excel 2

rahulsharma (Rahul Sharma) October 17, 2021, 2:45pm 4

Appreciate you tried.

Here is a workflow, this should help.

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Filter data from data table 1 to data table 2 Studio uiautomation	7	936	September 28, 2021
Excel Automation - Check and Identify duplicate records/rows Studio excel	11	3161	March 15, 2020
Check record in web page Help	11	1654	February 4, 2019
Check if specific value form dt1 exist in dt2 Studio studio , question , activities_panel	4	486	January 26, 2023
Check Duplicate records with specific condition/filter Excel Studio datatable , excel , activities , question	3	1043	March 23, 2020