Do you have any tips for handling recursive data in parabola?
Take the example below. The first table is a list of all of my items.
- Apple pie is a top level item
- Apple pie is made of Pie Crust & Apple Filling
- Pie Crust is made of Flour, Butter, and Sugar
- Butter is made of Cream and Salt
In this example I have a separate table of orders for 3 items. I want to be able to create a line for each of the 3 items ordered and their ingredients (the table at the bottom). If I always knew how many layers deep each line would be (Apple pie was 4 layers deep), I could manipulate the data with multiple flows to get there. However as my items get more complex, the layers involved will increase. I would like to set up a flow that is sure to capture all layers of the data. Do you have any ideas for handling this?