Defining Parameters on Closest Value

Hello,

I’m working with a dataset (attached below) where there are multiple sizes for a single “Item”. The goal is to have only 5 sizes per “item”, where each size is specifically 1, 5, 25, 100, or 500. However, if any of those specific sizes are not available, then choose the item with the closest next value.

Some items may not have a total of 5 sizes (i.e. an “item” could only have 1-4 sizes), then that’s okay, still would like to retain the same logic above (i.e. choose the closest value to 1, 5, 25, 100, or 500) for all available sizes.

Really appreciate the community’s support!!

Thanks,

knime_ex.xlsx