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