2-2: If you need to join tables based on column
Use Recursive Loop Start and Recursive Loop End node to create the loop construct. The first Excel file would be the input for the loop start (And should be filtered from the list).
Step 3: Read Excel files
Use the Excel Reader (XLS) node, and set the location from the list you have.
In case of 2-1, they get converted to flow variables one by one in each loop.
In case 2-2, you have to convert them to flow variables one by one in each loop iteration by yourself.
For both cases, if your tables have column headers, set the corresponding option in the Excel Reader (XLS) node configuration and also check “Disable Preview”.
Step 4: Final step
In case 2-1 you have nothing to do. Just execute the loop.
In case 2-2, use the Joiner node, top port comes from the Loop Start node, bottom port from the Excel Reader which reads the files from the list. You have to split the list and include a single file based on the current iteration number to feed the first Excel Reader node. The output of the Joiner node goes to both input ports of the Recursive Loop End node. In the configurations of the Recursive Loop End check the option to collect data from the last iteration only.