Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Convert multiple fields in a column into 4 headers

bmyles
6 - Meteoroid

Hi everyone,

 

I have a dataset where each item number has 4 rows associated with it, but it needs to be converted into 1. This means each of the 4 attributes associated with that item number should be a header, and the Boolean value should go under that header. 

 

The image attached shows the transformation that needs to happen more clearly.

 

Any help would be greatly appreciated. ThanksExample.png

2 REPLIES 2
ponraj
13 - Pulsar

Here is the solution for your case. Cross tab tool will help you to get you the desired results. 

Sample dataSample dataWorkflowWorkflowResultsResults

bmyles
6 - Meteoroid

Thank you very much!

Labels
Top Solution Authors