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


Terms & Conditions