Check if Record from Excel 1 is Exist on Excel 2

[Vincent_Nuestro]

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.

Kind Regards

• Vincent

[rahulsharma]

you can read the target excel using Read range in dt2

you can read the source excel in dt1 and then use for each data row for that.

In the loop, take the Person Number, and use a lookup datatable for dt2, in that pass the column name of the second excel “Person Number”, and take the rowindex output in a variable, intRow

if the intRow is less than 0 that means item do not exist, then you can mark that as Failed in a column of the the dt1

Remember, for each data row for the source data and lookup on the target data

Hope this helps!

[Vincent_Nuestro]

hi @rahulsharma

Thanks for your response, but would you mind sharing a workflow or Screenshot of it?

sorry im having a hard time to figure it out.

Regards
-Vincent

[rahulsharma]

Hey @Vincent_Nuestro

Appreciate you tried.

Here is a workflow, this should help.

ToCheck.zip (14.8 KB)

[Vincent_Nuestro]

hi @rahulsharma

ir replace my Column Header

[rahulsharma]

While using the write line, in the property panel. check the checkbox for Have Headers

[Vincent_Nuestro]

Thank you, it works now:) @rahulsharma