Consolidate Multiple Excel Files into one -

Apologies, poor word choice I didnt mean to belittle the problem, glad you were able to find a solution though!

Just a tip hereā€¦ when you use the excel node, you can set to see all excel at a folder and create a master one at onceā€¦ load all data. I saw a screen above that you have 2 paths (excel folder 1 and excel folder 2). If the excel have the same structure, betterā€¦ simplify the process.

after that, just make a joiner process to match the cases by the key to fill the blanks and at the end, just make a single excel writer with this resultā€¦ Remember that excel have a limit of rows to be exported, maybe you can use CSV file for large data information and can use a chunk loop node to split it in files too.

If you have some doubts, can bring it to us again hereā€¦

Thanks,

Denis

Thank you for contribution

You donā€™t have to apologize. You didnā€™t offend me.
Here was my solution

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.