In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Data Blending

DDYY
5 - Atom
‎02-28-2021 04:09 PM

Integrate the two tables into a new table, and finally add a column of average values.

 

example.yxmd
Reply

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
AbhilashR
15 - Aurora
15 - Aurora
‎02-28-2021 04:57 PM

Hi @DDYY, you can integrate the two tables using the Join tool (something like the screenshot below), and then introduce a formula tool downstream to compute the avg.

AbhilashR_0-1614560225946.png

 

  

Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎02-28-2021 05:22 PM

@DDYY 

Is this your assignment? 😁
lets get you started.
Based on your results., you are looking at the difference between Year 2017 and 1997 actually, not the average.

Capture1.PNG

 

example-R1.yxmd
Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All