How to shuffle BOM quantities based on Product Carton Size Configuration

Hi Team,

Input File

I am building a Bill of Material (BOM) file. I have pre-processed the data to the point were each BOM component now has a Parent ID product key with carton size appended to it.

I would like to update BOM Qty field based on the Size Configuration Qtys for each

component which is stored on the file as shown above.

What is the best node to use. I have hit a brick wall trying to shuffle the BOM quantities based on the Product Carton Size configuration

Output Data would like below

Appreciate your help.

Thanks,

Sunil