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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.