Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Transposing Data, having difficulty getting the tool to output correctly

Adam_B
8 - Asteroid

Hello, 

I have a data set that uses unique rows with columns identifying different attributes (Is Large, Is Small, etc.)that I am trying transpose into columns but only maintain the appropriate attributes.  Which, I believe will have to be an additional step in the process.  I am new to Alteryx, so any help would be appreciated. 

 

Current State
SupplierIs Small Is LargeIs MediumIs LittleIs Tiny
Supplier AY  Y 
Supplier B YY  
Supplier C  Y Y
Supplier DYYY  
      
      
I need it to look like this:     
Future State    
SupplierName    
Supplier AIs Small     
Supplier AIs Little    
Supplier BIs Large    
Supplier BIs Medium    
Supplier CIs Medium    
Supplier CIs Tiny    
Supplier DIs Small     
Supplier DIs Large    
Supplier DIs Medium    
3 REPLIES 3
binuacs
20 - Arcturus

@Adam_B 

binuacs_0-1648070097605.png

 

Luke_C
17 - Castor

Hi @Adam_B 

 

Here's an alternative using the arrange tool

Luke_C_0-1648072344585.png

 

 

Adam_B
8 - Asteroid

Thank you!

Labels