Hello i'm trying to group sizes and the logic is something like this Case WHEN SIZE LIKE '251 - 499ML' AND PACK_SIZE IN ('300ml', '320ml', '330ml', '3960ml') AND Char_3='PLASTIC BOTTLE' THEN '300ML - 330ML'
WHEN SIZE LIKE '251 - 499ML' AND PACK_SIZE IN ('300ml', '320ml', '330ml', '3960ml','400ml', '450ml') AND Char_3='PLASTIC BOTTLE' THEN '250ML - 500ML'
else SIZE END AS SIZE,
in short i want the '300ML - 330ML' inside '250ML - 500ML' as well but doing it like this gets it excluded how can i address the problem
i just decided to put a second reading in another sheet one has the sizes needed the first time and the second has the sizes that need to be combined in another way
there probably is different approaches to this for instance i could just alter the data from the database and create the category i want in the end similar approaches to this since we cannot double the elements cause the margin of error is really thin
