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 merge 2 rows with different fields of different files in only one row

maxtla
8 - Asteroid

Hi,

 

I have 2 different files with a common field (ID). These 2 files has different fields, but I want to merge them in only one file with one row per ID.

How can I do this? I union tool but the result are 2 rows and I need only one with all fields.

 

Then I tried to transpose and then cross tab with the unique for avoiding double figures, but I noticed that there are still removing rows with data that I need...

Thanks for your help!

 

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

@maxtla instead of a Union tool which stacks data on top of each other, you'll want to use a Join tool to place matching rows side-by-side. In this case, you'll want your Join condition to be the common field i.e. [Action ID]:

 

DataNath_0-1664870935057.png

maxtla
8 - Asteroid

Thanks for your solution. sometimes I cannot see further...thanks

Labels
Top Solution Authors