Recursive data extraction

[feaugcruz]

Hello guys.
I'm analyzing some unit price compositions and I need to extract labor hours, equipment hours, and materials.
Some compositions have only these 3 items, but most of them have auxiliary compositions, that sometimes have other auxiliary compositions and the process becomes recursive.
For example:
_ In 'column B' I have the code of the main composition;
_ In 'column C', I have a code for a labor, material, equipment, or other composition;
_ In 'column D', the quantity;
_ 'Column F", the types (A - equipment, B - labor; C - material, D or E - auxiliary composition).

My objective is to create a list where I have only the "main" code and the items A, B, and C. For this, the items D and E must be multiplied by the quantity from the main composition.
I thought of using 'lambda, filter, map, and others' because I know they support recursivity, but I'm not entirely familiar with them yet.
Can somebody help me?

Sorry for my English, it's not my main language.

 

[Rijnsent]

Hi there,
welcome to the forum. I have a hard time trying to understand what you're trying to achieve, but my first idea to put your data into a pivot table. Is that something you've tried? Next, if you look for example at line 10376: it shows column B/MAIN:0903845 , column C/AUX: E9524, column D: 1,0000 and column E: h (probably hours). What is your ideal outcome? The total of hours for E9524? Or is there another table to multiply with ("the quantity of the main composition")?
Cheers,
Koen