I am exploring ElasticSearch as a solution for one of our usecase. I wanted to know whether the current ElasticSearch capabilities could meet our requirements.
For our use case, we want to index excel files in our repository.
The excel files have a standard template. The data is present in 2 columns. Column A contains certain "questions" and Column B has the answers to those questions
For our use case, if the user searches for a question (say on Row 19 A, we want to be able to show him the answers in column B ( i.e Row 19 B).
From what I have read, I would have to use the ingest-attachment plugin to index the files. However once I have the files indexed, would I be able to map the contents of the files as "Key", "Value" pairs in the index to search on?
What would be the best way to go about this?