Hello,
I’m trying to consolidate some data in a custom dimension where
I have values like A1 A2 A3 A4 A5, B4, B6, B12, B13, C12, C2, C5, C6
I want to consolidate values under A, B, C only
So far i’ve been using this
if(contains(${delivery_modes.display_name}, "delivery"),"Delivery",
if(contains(${delivery_modes.display_name}, "signature"),"Delivery",
if(contains(${delivery_modes.display_name}, "royal Mail"),"Delivery",
if(contains(${delivery_modes.display_name}, "Standardversand"),"Delivery",
if(contains(${delivery_modes.display_name}, "post office"),"Delivery",
if(contains(${delivery_modes.display_name}, "Next day"),"Delivery",
if(contains(${delivery_modes.display_name}, "Collect"), "Collection",
if(contains(${delivery_modes.display_name}, "No"),"No delivery",concat("FIX--", ${delivery_modes.display_name})))))))))
but it is really painful, is there another way to do this efficiently?
I’m a newbie
Thanks