I have a data extension with a customerID and 15 products assigned to them(screenshot attached)
Some of the 15 products are missing the value and I would like to write a query so if Product1 is empty to get the value of Product2 and so on.
i.e. if product1 product3 and product5 are empty to show the first 12 products with the value inherited from the next product and last 3 products to be empty in this case because there is 3 empty products.
Is this possible?