community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Combine various data sources with NO unique key

Meteor

I have ~10 excel tables with varying columns, My aim is to connect sources based on a few common fields

 

What is the best method to do this? Im not having too much success with Join Multiple

 

so lets say I have

 

NameLocationColour
   

 

NameLocationSizeWeight
    

 

OriginNameLocation
   

 

If Name and Location match on say 1 and 3 I get:

 

NameLocationOriginColour
    
Alteryx Certified Partner
Alteryx Certified Partner

@jacques993,

 

Join multiple should work.  

 

capture.jpg

 

Here's a sample.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx Certified Partner
Alteryx Certified Partner

@jacques993,

 

P.S.  The join function is case sensitive.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteor

The join multiple doesnt seem to work in the case required.

 

I.e. if 2 data sources have name and colour and weight

then another has name and weight 

then another has weight and colour

 

how to combine these, if not the same fields on all 3?

 

Thanks

Labels