Loop within a Loop

Let me start by saying I have searched the forums and after a reading a number of past posts, I still don’t quite understand what the setup looks like for a loop within a loop. I am still getting my feet under me, but the use of nodes to start and end loops is baking my brain.

What I am looking to do:

  • For each file in a path, load the database (MS Access) at that path. This component of walking the directories and setting up the file paths for the parent loop, loop 1, is all set. I will come back to this issue in a moment.

  • After loading the database from the path as part of loop 1, identify the tables, and for each table, read the table and write it to another database. I will call this loop 2 logic. I have this working for a single year only.

In short, I have everything working the way I want, the only bit that is tripping me up is the top-level loop 1. It’s not iterating.

My question: Are there any painfully simple tips and tricks that show how to perform a nested loop, and show how the parent loop goes to the next iteration after the child loop completes its iterations?

This post indicates up to 4 nested loops are possible, even with recursion, so I am confident it can be done, but based on my setup, I am not sure why the parent loop (loop 1) does not iterate after it completes its iterations (~30).