validate between two excel

[sainath769]

I has Two coll A, B

Coll A has three columns Date , day Volume , Night Volume ,
Coll B had only Date , Volume with both Day and night values ,


now i want check whether all Day and night values present in are available in CollB.Volume for particular or not

 

[Pete_L]

Loop through Coll B and in that loop, filter Coll A for the Date and Reads values found in the Coll B row, and output the results to a new collection called Day Results. Count the rows in the Day Results collection and store it in a data item called Day Count. If Day Count > 0 you will know the Coll B Read value is in Coll A. Similarly, filter Coll A for the Date and Reads values found in the Coll B row, and output the results to a new collection called Night Results. Count the rows in the Night Results collection and store it in a data item called Night Count. If Night Count > 0 you will know the Coll B Read value is in Coll A.