I prepare a list of all purchase orders for a company on 25th every month and send to my company counter parts (three persons) asking for comments. They copy my file and create three different versions in their names and save comments.
On 31st, I prepare an updated list of purchase orders and now I would like to bring in all the comments saved by my counter parts in three different files. In this case, comments to be copied from three spreadsheets to one spreadsheet with a matching column in both the sheets. I do this data aggregation in excel spreadsheet by using Vlook up formula manually. Now would like to simplify this with Knime.
Please suggest which node is suitable for this simplification.