Alteryx Designer Desktop Discussions

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

Convert one column to multiple columns based on column values

VishyReddy
7 - Meteor

Hi, I have recently started using Alteryx. I am trying to convert one column into multiple columns based on the column value. Can some one tell me the workflow to achieve this. See below

 

Capture.PNG

10 REPLIES 10
VishyReddy
7 - Meteor

Hello @jrgo,

 

Thanks for the solution. But I have encountered a problem with the solution. if the labels have 2 instances of CU and CH each, it still generates 2 rows instead of 4.

 

Labels