community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

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

data preparation

Highlighted
Meteoroid

can someone help me prepare data like shown below, input and output.
snip.PNGdata 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.

Pulsar

Is this what you're looking for?

 

data prep.png

Meteoroid

yes exactly, thanks.

Pulsar
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.
Meteoroid

thankyou