I have about 100 Excel files into a folder and I would like to compile based on a list of Keywords, a list containing the path of the file and the Keywords hit. I am not really sure on to process on with this. The Excel file are not into a table structure, there is text everywhere and merged cells. I downloaded the Text Processing Extension with big hope but I don’t know how to set it up properly to handle Excel files.
Is it something feasible with Knime ?
Thank you !