Hi!
I am trying to create a bigger workflow which contains data about: SKU, Season, Ranking of the season and a new column which is called " Carryover".
In short, the file sometimes contains duplicates of the SKUs number, but that SKU has different season: e.g. SKU: 110 can be found in both FALL, SUMMER and SPRING.
The seasons are also ranked by their relevance: 1- most recent to 4- oldest.
I need a workflow which:
1. For the duplicates, in the Carryover column is taking the names of all the other season where is present:
e.g.: SKU 110, Season: FALL, Carryover: SUMMER, SPRING
SKU 110, Season: FALL, Carryover: SUMMER, SPRING
2. In the case that specific SKU is present in multiple seasons, I only want to keep the most recent one.
Example:
INPUT:
| SKU | SEASON | RANK |
| 110 | FALL | 1 |
| 110 | SUMMER | 2 |
| 110 | SPRING | 3 |
| 111 | FALL | 1 |
| 112 | SPRING | 3 |
OUTPUT
| SKU | SEASON | RANK | CARRYOVER |
| 110 | FALL | 1 | SUMMER,SPRING |
| 111 | FALL | 1 | |
| 112 | SPRING | 3 | |
Note:
1. As seen above, the SKUs which only appear once, do not need to be removed.
Thank you in advance!
