Looping Help

I am looking for some guidance in looping. I am pretty new at maps and particularly in looping so any help is appreciated.

The data is parent child relationship based but is multiple levels deep (ten). The problem is that the schema I have only defines one level, so I have to derive the looping myself which is why I need some help.

For example, if I had the following:

ID 1 – LEVEL 1 – PARENT 0
—ID 2 – LEVEL 2 – PARENT 1
——ID 3 – LEVEL 3 – PARENT 2
—ID 4 – LEVEL 2 – PARENT 1
——ID 5 – LEVEL 3 – PARENT 4
———ID 6 – LEVEL 4 – PARENT 5
—ID 7 – LEVEL 2 – PARENT 1
——ID 8 – LEVEL 3 – PARENT 7

However my schema would be something like this:
LEVEL
—id int
—level int
—parent int
—levelfield1 varchar
—levelfield2 int
—dataset
——field1 int
——field2 int
——field3 varchar

Where I might need to get data from both the levelfield data or the dataset fields.

Hope this makes sense. If you are familiar with the EDI 811 x12 format, I am talking about the HL levels, but understand my source schema is not \”flat\” but has all the levels grouped up into.

Thanks in advance for any help.