Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Join different sets of data

amrutkasyap
7 - Meteor

Hello,

 

I need help in joining these records and creating the correct number of records. I have listed the steps below.

 

  1.  Duplicate the first set of data and rename the record status to - 'Check'. This becomes third set of data
  2. Based on Key and MAT, copy only Seller information from Second set of data to third set of data. All the other info will be from first set of data
  3. Combine all these data to get a output of 12 rows.
  4. The columns are the same across all sets of data. There are 50 other columns have not listed all the other columns.

I am getting twice the number of rows in the final output. I have tried using unique tool but unable to get correct output. Any help is appreciated.

 

Thanks

 

First set of data

MATTypeKeyRecordStatusDateSellerSeller_CitySeller_NumSeller_NameSeller_StateShip-To CityShip-To Name
1014061601881DEST1/1/2001  3716 Company LOS ANGELESLLC
1014061601881DEST1/1/2001  3716 Company LOS ANGELESLLC
1014061601881DEST1/1/2001  3716 Company LOS ANGELESLLC
1014061601881DEST1/1/2001  3716 Company LOS ANGELESLLC

 

Second set of data

NumTypeKeyRecordStatusSellerDateSeller_CitySeller_NumSeller_NameSeller_StateShip-To CityShip-To Name
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  

 

Third set of data

MATTypeKeyRecordStatusSellerDateSeller_CitySeller_NumSeller_NameSeller_StateShip-To CityShip-To Name
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  

 

Final Output

MATTypeKeyRecordStatusSellerDateSeller_CitySeller_NumSeller_NameSeller_StateShip-To CityShip-To Name
1014061601881DEST 1/1/2001 3716 Company LOS ANGELESLLC
1014061601881DEST 1/1/2001 3716 Company LOS ANGELESLLC
1014061601881DEST 1/1/2001 3716 Company LOS ANGELESLLC
1014061601881DEST 1/1/2001 3716 Company LOS ANGELESLLC
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  
1014061101881ORIGIN50397/7/2007FORT WORTH2016AA LLCTX  
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  
1014061601881CHECK50391/1/2001FORT WORTH2016AA LLCTX  
2 REPLIES 2
MichalM
Alteryx
Alteryx

@amrutkasyap 

 

Based on what you described the attached should work. I made some assumptions so please let me know if anything doesn't make sense

 

join-data1.png

amrutkasyap
7 - Meteor

Thank you that worked..

Labels