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

Alteryx Designer Desktop Discussions

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

Need help on where to start as there are relation between all the columns for data prep.

ajanayak
8 - Asteroid

Please help me on this issue as I am confused to get it started as I have multiple rows having inter connected in terms of getting value.

 

Attached the data input with comments and formula.

 

 

Thanks

AJAY

1 REPLY 1
Yoshiro_Fujimori
15 - Aurora

@ajanayak 

As it is easier to deal with time-series data in rows, than in columns, I exchanged the columns and the rows.

 

Workflow

Yoshiro_Fujimori_0-1678152253341.png

 

Output

Yoshiro_Fujimori_1-1678152401975.png

I hope this works for you.

 

Labels
Top Solution Authors