I have an xlsx file and I have loaded most of the sheets in transposed manner in oracle.
Ex:- Xlsx :
Now, roll number 1 in the Oracle table has three rows, but only one in the XLSX file. How can the count and value be confirmed to be the same when comparing table data with sheets?
Is it possible to develop a script to compare the sheets with the tables once the data has been loaded?
I attempted using macros, but I was unable to do so because the sheets would need to be changed every six months. I also tried a couple of queries like groupBy.