Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

How to pivot from column to rows

abalo006
Level 3
How to pivot from column to rows
 

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

piv.PNG

 

Output

piv2.PNG


Operating system used: windows


Operating system used: windows

0 Kudos
3 Replies
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?

0 Kudos
abalo006
Level 3
Author

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

0 Kudos

Screenshot 2024-04-30 at 19.57.58.png

0 Kudos

Labels

?

Setup info

?
A banner prompting to get Dataiku