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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Merge rows and columns

Atom

[new user, first post!]

 

Below is sample data in the form of 3 small tables, along with the desired output I am looking for in my merge. When I do it currently using the join tool I get the output at the bottom, so I'm doing something wrong.

 

An easy one for many of you experts I'm sure!

thanks.

Diarmuid

 

Input 1

TownApples
Londonyes
Birminghamno
Chelmsfordyes
Leedsno

 

Input 2

TownOranges
Londonyes
Birminghamyes
Chelmsfordyes
Leeds

no

 

Input 3

TownBananas
Londonno
Birminghamyes
Chelmsfordno
Leedsyes

 

Desired Output

TownApplesOrangesBananas
Londonyesyesno
Birminghamnoyesyes
Chelmsfordyesyesno
Leedsnonoyes

 

Current Output

TownApplesOrangesBananas
Londonyes  
London yes 
London  no
Birminghamno  
Birmingham yes 
Birmingham  yes
Chelmsfordyes  
Chelmsford yes 
Chelmsford  no
Leedsno  
Leeds no 
Leeds  yes
Alteryx Certified Partner

Hi @Diarmuid 

 

Are you using the Join Multiple Tool?

 

If you join by "Town" Field I don't see why you wouldn't get your desired output.


Cheers,

Alteryx Certified Partner
Alteryx Certified Partner

A JOIN MULTIPLE tool should do the trick:

 

capture.jpg

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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

@Diarmuid 

 

See screenshot:

 

merge1.PNG

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@Thableaus,

 

Looks like we're tied for the solve on this one :)

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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

@MarqueeCrew 

 

So true! I think our solutions wouldn't look so similar as they do if we had planned to post together hahaha.

 

Cheers,

Atom

thanks guys. Seems I over-simplified my data, and my problem was elsewhere. I had an extra columns in there which had [in places] different values in each row, with the result that Alteryx treated each row as a unique record and therefore made separate lines, as per my original post. When I removed those columns then I got the desired result. School boy error!!!

Labels