Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

data preparation

sujithgk
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.

4 REPLIES 4
DavidP
17 - Castor
17 - Castor

Is this what you're looking for?

 

data prep.png

sujithgk
6 - Meteoroid

yes exactly, thanks.

DavidP
17 - Castor
17 - Castor
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.
sujithgk
6 - Meteoroid

thankyou