In above 2 files I need to do following :
a) In file A and B I need to check if value of column “Ver” is same then check value of “Rank” (in file A) and all values under columns 1-12(File B)
If value of Rank in File B (all those values which are greater than the highest value of Rank in file A) is more then copy all such values (add new rows) under respective column(1-12) in File A with same value Col1 and Col2. This should happen with all set of rows in both files.
Ex in above case for “Ver=AAR01” 2 new rows should be added in File A for each rank value (4-5 in File B) along with exact value of these ranks from File B.
and for Ver=BBC01 , 3 new rows (as ranks 10,11,12 in File B are greater than highest value of Rank =9 in file A) should be added in File A:
How to check the condition and copy cell value from File B to File A. I am using datatables for both files but how to specify to pick specific cell value in iterative way. I checked previous posts but there’s no query like this.