I have two 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.
Use lookup datatable activitiy to check whether a value in input file is in master file
Hope it helps you
Check the below post’s test zip file
Hope this helps you