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).

Loop within a Loop

mlauber71 January 16, 2025, 8:52am 3

@Brock_Tibert one idea can be to enclose the inner workings of a loop in a Metanode or Component. Also you can try to select the scope (right click) and see if the logic does make sense. Maybe you can provide a screenshot.

4 Likes