Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dates

magsbiel
7 - Meteor

Hi,

 

I need to transpose the data. I have a promotion that is running from 6/28/2020 to 07/26/2020. First I needed to convert those weeks to weeks that the first day of the week is Sunday, which I did, so now the promotion is running from 7/5/2020 to 7/19/2020. Now, I need to take that one row and change to three separate rows with the same attributes, but that will show me each week on the separate line: 7/5/2020, 7/12/2020 and 7/19/2020. I attached current view and desire output. Does anyone know how to do it? 

4 REPLIES 4
Amarendra
10 - Fireball

@magsbiel  Please check the attached solution

 

Screen Shot 2020-09-16 at 12.20.25 PM.png

 

vizAlter
12 - Quasar

@magsbiel  â€” Hope attached the solution will be helpful, if not let me know.

 

vizAlter_0-1600274281041.png

 

magsbiel
7 - Meteor

It worked. Thank you!

magsbiel
7 - Meteor

Both solutions worked. Thank you!

Labels
Top Solution Authors