Forum Discussion

JPNK's avatar
JPNK
Frequent Visitor
3 years ago
Solved

Merge columns as new events

Hello all, I've been trying to find a solution to my problem, and I haven't been able to work it out. Probably I'm not using the correct keywords, as when I search for "merge columns" it usually dir...
Need Help
  • JPNK's avatar
    JPNK
    3 years ago

    Actually I already figured it out.

    So the solution for me was to merge all colors into a new column

    all_colors = Product_colors[Color1]&","&Product_colors[Color2]&","&Product_colors[Color3]

    then I clicked on split column by delimiter

     

    On spliting, I chose to split into rows instead of columns

     

    After that I just filtered out all the blanks from this new column, and job done.

     

    Thanks to anyone who read this request

Einomi's avatar
Einomi
Helper V
3 years ago

Why not a simple Unpivot Other Columns ?

You select the following columns : SKU, Product Type, Arrival Date, Stock

Then right click > unpivot other columns

This way if you get more colours in the future it will update, in your solution JPNK  you assuming you cannot get more than 3 columns...shame to hardcode this, with unpivot it will work even if you get more than 3 colours

JPNK's avatar
JPNK
Frequent Visitor
3 years ago

That's a good idea. Right now the product only has 3 color specs, but if this changes I'll definitely consider your suggestion.

Thanks for the input