Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music

Connecting multiple tables

Highlighted
8 - Asteroid

 

Hi All,

 

I have two data sets in table format as shown below.

 

Cost.JPGUsage.JPG 

I want to combine these two tables in below format, any idea?

 

Combine.JPG

 

Highlighted
ACE Emeritus
ACE Emeritus

Hi!  I tried this by giving each data table a new field called either 'Cost' or 'Usage', unioning all data, and then sorting by Site ID and the new 'Cost'/'Usage' field.Connecting Multiple Tables.PNG

Labels