In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to structure data in a horizontal table

AgiGovind
6 - Meteoroid

Hello,

 

I have a requirement of arranging data in multi horizontal table. Any advice on how to achieve this is greatly appreciated.

 

Below sample, i am trying to compare the client payment date and amount with my system details.

 

Input 1 

Pay DateClient  Client  Client  Client  Client 
 AAA BBB CCC DDD EEE
11/1/2024         
11/2/2024         
11/3/2024         
11/4/2024$600        
11/5/2024         
11/6/2024  $700      
11/7/2024         
11/8/2024    $900    
11/9/2024         
11/10/2024      $550  
11/11/2024         
11/12/2024        $250
11/13/2024         
11/14/2024         
11/15/2024         

 

Input 2 

 

Pay DateMy SystemPayment
11/4/2024AAA#$600
11/6/2024BBB#$700
11/9/2024CCC#$900
11/10/2024DDD#$550
11/13/2024EEE#$250

 

Output:

 

Pay DateClient My SystemClient My SystemClient My SystemClient My SystemClient My System
 AAAAAA#BBBBBB#CCCCCC#DDDDDD#EEEEEE#
11/1/2024          
11/2/2024          
11/3/2024          
11/4/2024$600$600        
11/5/2024          
11/6/2024  $700$700      
11/7/2024          
11/8/2024    $900     
11/9/2024     $900    
11/10/2024      $550$550  
11/11/2024          
11/12/2024        $250 
11/13/2024         $250
11/14/2024          
11/15/2024          
1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@AgiGovind 
Manipulating non-structure data to non-structured data is not really the strong point of Alteryx.
but anyway, maybe we can something as below.

1118-Agi007.png

Labels
Top Solution Authors