How to pivot from column to rows

abalo006

I have data that has a column with the days of the week, source and season. I'm trying to split my days column to rows.

I have picture of my current input and expected output. I tried to use the split function but that split the days into different columns not rows.

is there a way to get my desired output using dataiku?

Input

Output

---

Operating system used: windows

---

Operating system used: windows

Turribeach

This is probably easier to do in Python but I am not sure if you are looking for a solution using visual recipes or code recipes. Also are the number of days in the Days column always 7 and always all the days of the week (ie Mon-Sun)? Are you using a SQL dataset?

abalo006

so ideally, I was looking for a visual solution or via code in the prepare recipe. sometimes the number of days can be 1 or 2 Ex. WED,THU

Turribeach