Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

data preparation

Highlighted
6 - Meteoroid

can someone help me prepare data like shown below, input and output.
data to be prepared as shown in the outputdata to be prepared as shown in the output

so basically i have two columns x and y, x tells the process which has cyclic readings(no fixed number) and y are the readings for x cycle process,

as the processes are not fixed in a cycle , i want to prepare a new table, which has maximum process and all other data readings with different columns for each cycle.

 

can some one help me with this.

Highlighted
16 - Nebula

Is this what you're looking for?

 

data prep.png

Highlighted
6 - Meteoroid

yes exactly, thanks.

Highlighted
16 - Nebula
You’re welcome. Feel free to mark it as a solution to help others on the community who are searching for solutions to similar problems.
Highlighted
6 - Meteoroid

thankyou