Trying to setup logic for Bill of Material (BOM) for a system

Hi Team
I am trying to setup logic for typical BOM data. I am not sure if this forum is appropriate to ask such elaborate logic.

Example Data

I have two Types of BOM Nested & Carton 1 of 2 (Maintained in 2 columns)
and a column to indicate if it is a Parent for the component -Yes/No

Loop Start
IF "is it a Parent=Yes and Ctn 1 of 2 =‘Yes
create the Parent ID BOM by joining the Item (first item)+ "CTN’ constant
Write the BOM Component records (3 Records) - Each Item in the list which has Ctn 1 of 2 = Yes
END Loop When Is it a Parent =No and Ctn 1 of 2 =No

IF "is it a Parent=Yes and Nested ='Yes
create the Parent ID BOM by joining the Item + Sizes (“XS”,“S”,“M”,“L”,“XL”) - Additional Requirement is create Parent Id only if the sum of the component qtys for a given size >0
Write the BOM component records (4 Records)
END Loop When Is it a Parent =No and Nested =No

Expected OUTPUT

image

Thanks for help in advance

Sunil

@Suniljc maybe you could provide an example file and a corresponding result covering the whole of your challenges.

Hi Markus,
I thought the example dataset and the expected output was in the body of the message. Attached is the data set again
Rangeplan Item Load-forum logic.xlsx (12.0 KB)

Thanks,
Sunil

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.