Hello,
Hope you are doing well.
I've automated the search and download of various files on specific companies from different sources. All files are saved in a dedicated folder. Now, I'd like to merge the files together following a condition (here all company A files together, company B all together etc...)
I've now managed to filter my collection, i.e. having a temporary output collection only with the company A files. Now, from this temporary collection (let's say there are 4 rows in the collection), I'd like to actually merge the 4 files together with the condition to have one tab in the Excel per file (i.e. here 4 tabs)?
Could you please help?
Thanks
Hope you are doing well.
I've automated the search and download of various files on specific companies from different sources. All files are saved in a dedicated folder. Now, I'd like to merge the files together following a condition (here all company A files together, company B all together etc...)
I've now managed to filter my collection, i.e. having a temporary output collection only with the company A files. Now, from this temporary collection (let's say there are 4 rows in the collection), I'd like to actually merge the 4 files together with the condition to have one tab in the Excel per file (i.e. here 4 tabs)?
Could you please help?
Thanks