I need to compare two excel reports (old and new), each reports have ~200 columns and each row in the old excel has a corresponding row in new excel sheet, also each row has a unique mapping by a combination of fields.
I am planning to convert these excel reports into a json document and store it in elastic search with an index and type.
But am pretty new to elastic search and Kibana, could someone please help me in comparing the reports.
Basically I need to compare how much percentage each columns matches with old and new and other statistics?