Pivot in Save search

Hi,

I created a saved search that generates a price list for our customers. For each sku we have 3 records:

1. base price from the parent sku

2.base price from  child A ( for custom over a specific size).

2.base price from  child B ( for custom under a specific size).

 

 

SKU    SIZE                    PRICE

 

2118.   small/large          $10

2118.   custom A             $20

2118.   cusomb b            $30

 

Is there any way I can  Pivot the data so the output will be like this :

 

 

SKU    SIZE                    PRICE.    price A.   price B

 

2118.   small,large.       $10.         $20            $30

Thanks in advance.

K

Rookie Asked on February 25, 2020 in Best Practices.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor