Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Concatenate all of all values in field 1 to each value in field 2

Highlighted
7 - Meteor

Hello,

 

I would like to get every combination of the following data:

CountryName
FranceKyle
GermanyChloe
SpainJohn

 

so it looks like this:

Country Name
France Kyle
France Chloe
France John
Germany Kyle
Germany Chloe
Germany John
Spain Kyle
Spain Chloe
Spain John

 

I tried using cross tab to get the countries along the top but then it leaves it as this:

 FranceGermanySpain
Kyle   
Chloe   
John   

 

I feel like I am on the right track, but I need those blanks to be populated and then for them to all be in one column, like the 2nd table example. It also needs to be a scalable and flexible solution as in my actual data set, the numbers in both fields will vary

 

Thank you in advance for your help!

 

Highlighted
Alteryx Partner

Hi @thrnma ,

 

You will have to use the Append Fields tool for that. Check the attached workflow please, I think it will give you what you are looking for

 

Screenshot 2020-10-16 133658.jpg

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@thrnma ,

 

if you take the data into an append field tool, you can read column 1 as target and column 2 as source and get the results by then creating a formula of:

 

[field1] + " " + [field2]

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

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

@AngelosPachis 

 

Thank you for this solution.

 

I have tried putting it into my workflow but my results come up like this:

Country Name
France Kyle
France Kyle
France Kyle
Germany Chloe
Germany Chloe
Germany Chloe
Spain John
Spain John
Spain John

 

Do you know why this is happening?

Highlighted
15 - Aurora

Hi @thrnma 

 

Make sure you append tool is configured like below.

atcodedog05_0-1602853715066.png

Country from target and name from source

 

In your scenario its seems both are from same(either both target or both source)

 

Hope this helps 🙂

Highlighted
7 - Meteor

@atcodedog05 

 

Brilliant, thank you for your help.

 

And thank you everyone! Works perfectly

Highlighted
15 - Aurora

Happy to help 🙂 @thrnma 

 

Cheers and Happy Analyzing 😀

Highlighted
Alteryx Partner

I think it's because the Append fields tool is misconfigured. Could you please make sure that the boxes are selected as shown in the following image

 

Screenshot 2020-10-16 141310.jpg

Labels