Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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