Skip to main content

Hi all,



I’m facing the following challenge:



I have a table with a list of Product items (Catalog), to simplify the question I have 3 columns:



Product name | Product ID | Sizes


e.g.


Red Tshirt | 14828 | S,M,L


or


Blue boots | 5423 | 8,9,10,11,12



I need to take a single row and duplicate it & split it per each size as the following:


This original row:


Red Tshirt | 14828 | S,M,L



Should become this:


Red Tshirt | 14828 | S


Red Tshirt | 14828 | M


Red Tshirt | 14828 | L



(So all the other columns have the same values)



Has any 1 ever encountered something like this?



Thanks 🙂


YV

Hello @Dropit_Shopping,



It is doable using a script. Where do you want to put the new rows? In the same table as the source row? Or in a new table somewhere? A little more context about your problem would help.



-Raminder


Reply