How to check whether data is available in excel or not

I have two excel
1-input file
2.Master excel.
with only one column .
I need to check if the value is already available in master file i shouldn’t take up I need to proceed which are the value not available in master excel.
how to do that… any solution

please suggest some idea

You can read both excel files and store them as a dataTable. For example masterDT and inputDT. Then you can a For Each DataRow activity to loop through to inputDT and the masterDT to verify if a given row in the inputDT is not in the masterDT.

Hi @vaish

Use lookup datatable activitiy to check whether a value in input file is in master file

Hope it helps you

Nived N :robot:

Happy Automation :relaxed: :relaxed:


Check the below post’s test zip file

Hope this helps you