Process to show data one row after the other according to some conditions

[asifmaula2015]

Hi All,

I have a requirement where I have to create a dashboard for BOM(Bills of Materials). Let me tell you what BOM is all about. There are some Materials which is having respective Components under it. These Components are further divided into Sub-Components which is under the same field i.e. Material. There is a flag known as Assembly Indicator which signifies if any Components is broken down into Sub-Components or not. The values of this flag are either 'X' or 'Null wherein 'X' tells us that the Components has child components(sub-components).

So my requirement is to publish these lines one after the other. Please see the example below:

Material	Component	Assembly Indicator
Mat1	Comp1	X
Mat1	Comp2
Mat1	Comp3	X
Mat2	Comp56
Mat3	Comp87
Mat7	Comp6
Comp1	SubComp1	X
Comp1	SubComp2
SubComp1	SubComp76
Comp3	SubComp33

So it should look like below table:

Since Material 'Mat1' has Component 'Comp1' and has an Assembly Indicator flag as 'X' so it's component line should be published/displayed soon after this Material 'Mat1' details and so on. It should display all the sub components detail unless it finds a Null flag.

Material	Component	Assembly Indicator
Mat1	Comp1	X
Mat1	Comp2
Mat1	Comp3	X
Comp1	SubComp1	X
Comp3	SubComp33

I hope I was able to explain. Eagerly awaiting your reply.

Thanks in advance.

Regards,

Asif

[marcus_sommer]

Have a look here: Bill of Materials

- Marcus