Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Combining tables into one table (as total)

ultrarunner
8 - Asteroid

Hi there,

 

I have 2 identical tables:

 

 n1n2n3n4n5
A2    
B     
C     
D     
E     
F     
G  8  
H     
I    9

 

 n1n2n3n4n5
A   5 
B     
C     
D     
E     
F     
G 97  
H     
I    1

 

I need to combine them into one table, and the numbers should be combined as well:

 

 n1n2n3n4n5
A2  5 
B     
C     
D     
E     
F     
G 915  
H     
I    10

 

Is there any easy way to achieve this?

 

Thank you,

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @ultrarunner I mocked up a workflow let me know what you think?

ultrarunner
8 - Asteroid

Hi @JosephSerpis,

 

Thank you so much! I was not sure how to combine the tables. Union tool should do it.

 

Regards,

 

Labels