I'm new to Boomi and wondering if it is possible to perform the following with the tool. Let's say I have a folder on my machine that contains a collection of excel files. Excels can be added or deleted from this folder, so the number of files varies over time. I am interested in writing one Boomi process that would be able to iterate over each of these excel files, performing the same action on each of them. The excels are all using the same template, though will have different numbers/data within them. I want to be able to output 1 or more outputs for each file. So, something like:
Excel 1 --> 1 or more Excel 1 specific outputs
Excel 2 --> 1 or more Excel 2 specific outputs
So far, I have only seen how to link explicitly to a particular input file. I am wondering if it is possible to instead have a process run over a collection of files instead without having to make a different process for each input in the collection. Does anyone know whether something like this is possible and if so, could provide a link to some documentation on how to do it?
Thanks so much!