Alteryx Designer Desktop Discussions

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

Joining Row and COlumn intersection into a table with rows

Nicole_Marx
6 - Meteoroid

Hi Alteryx users, 

 

I am looking for a method to take the intersection of my rows and columns and create a new table from it but just showing the (intersected) data in the rows instead. 

Current state   
 AB10CD10EF10
CD1010  
EF10 100 
IE10  10000
    
Desired State   
CD10-AB1010  
EF10-CD10100  
IE10-EF101000  
2 REPLIES 2
aatalai
14 - Magnetar

@Nicole_Marx this should help, let me know how you get on

Nicole_Marx
6 - Meteoroid

great! a simple solution! thank you

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels