Free Trial

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
Top Solution Authors