DATA TRANSFORMATION

[razzy]

Hi everyone,

Hope everyone is keeping safe, i need help with transforming this dataset attached. Ideally i would want my coulmns to look like what i attached as " actual" in the sense that i want to make a the following transformation in the column field labelled name to be

"ID", "recorded_time" , "value" , "time"

For every ID that has unique values to all these fields in the data set these value are reported as the in the sheet "actual".

Please ignore the 400 values generated in the ID field the ID is the same in the data set for every unique entry.

Thanks in advance.

[razzy]

Please 

[CKP · Accepted solution]

Hi @razzy 

I believe this workflow produces the result you're looking for.

I hope this helps

Let me know if you have any questions.

[CharlieS]

Hi @razzy 

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

Learn more about Accepted Solutions here.

Happy Alteryx-ing!