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.

Append two different data sets next to each other that will output to different tabs

aishwarya_baburaj98
6 - Meteoroid

I have two inputs: 

 

Input A

CountryFruitsAmount 
USAApple 500
USAOrange600
IndiaBanana700
New ZealandKiwi800
IndiaMango900
PakistanPineapple1000

 

Input B

A1B1C1
USACreated byAlex
USAPosted byLia
USAReviewed byJohn

 

I want to out Input A and B , side-by-side, to different tabs based on Country in common. 

 

So, For example, in my output file, i would have a tab named  "USA", with below as my output:

 

CountryFruitsAmount B1C1
USAApple 500Created byAlex
USAOrange600Posted byLia
   Reviewed byJohn

 

How can I get this?

2 REPLIES 2
MatthewO
Alteryx Alumni (Retired)

@aishwarya_baburaj98 the attached workflow demonstrates how this is possible using the "Join by Record Position" configuration in the Join Multiple tool.

 

image.png

image.png

Jay-RDC
8 - Asteroid

jayrdelacruz18_1-1655323631127.png

Just use input data tool instead of input Text. Then join fields By "Country" and "A1". Enjoy!

Labels
Top Solution Authors