I've got the following table:
Building_ID, Color, Size, Roof
1,Red,1-10m,Flat
1,Blue,30-40m,Tiles
1,Green,20-30m,Flat
1,Red,20-30m,Tiles
Now, I also have this related table which I want to populate:
SubBuilding_ID,Item_ID,Subitem_Work,Subitem_Amount,Subitem_Units,Subitem_CPU
I want to populate this using the following external file:
Work_ID,Color,Size,Work,Amount,Units,CPU
001,null,1-10m,Paint,10,Liters,5
002,null,10-20m,Paint,10,Liters,5
003,null,20-30m,Paint,30,Liters,5
004,null,30-40m,Paint,40,Liters,5
011,Red,null,Flat,Flat Roof,100,m2,10
012,Red,null,Tiles,Flat Roof,1000,pieces,2
011,Green,null,Flat,Flat Roof,100,m2,8
012,Green,null,Tiles,Flat Roof,1000,pieces,1.50
011,Blue,null,Flat,Flat Roof,100,m2,6
012,Blue,null,Tiles,Flat Roof,1000,pieces,1
Now, I can get multiple Work types per Building, so I've got a 1:n relationship. The Excel layout is still up for debate, so it can be changed.
I just can't find out how I would build rows using the external Excel. FeatureMerger is not an option, since it's 1:1...
How would I go about building actual rows in this issue?
Thanks in advance.