cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

basic join on excel fields

Highlighted
Meteoroid

hi there,

 

i have 3 dummy files I am simply trying to join 3 cells on and make them be 1 cell next to it in the output file see attached

 

so Cell 1a on 123.XLS is "123"

     Cell 1a on 456.XLS is "456"

     Cell 1a on 789.XLS is yep, you've guessed it "789"

 

all i want the out put to have is a cell which is "123456789"

 

Simple right?

:)

Alteryx Certified Partner

First off, make sure you format these fields as strings so they can be concatenated. I used the Transpose tool to rearrange the fields so they could be summarized together into the desired output.

 

Check out the attached solution and let me know if that works for you.

Alteryx Certified Partner
Alteryx Certified Partner

@JBlair,

 

An Excel file with just one cell?

 

Here's a yxmd that will read that cell and solve this in a slightly different approach from @CharlieS.

 

capture.jpg

 

 

Alteryx ACE & Top Community Contributor

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

Nice work as usual, @MarqueeCrew. I was focused on the fields and not the files.

Alteryx Certified Partner
Alteryx Certified Partner

@CharlieS,

 

I have doubts that the answer that I provide will actually work with real world data.  The files likely include data past A1.  I just thought that I'd throw another technique into the mix so that it was out there...

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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

Thanks Charlie,

 

It works for the most part, but im still getting commas on the concatenated output as per attached?

Meteoroid

its 3 excel files, with one cell in each that i want to combine

 

like the attached, but i cant get rid of the commas!!!

Alteryx Certified Partner
Alteryx Certified Partner

@JBlair,

 

Does that mean that my approach doesn't work?

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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

havent checked yet, but im sure it does :)

Alteryx Certified Partner

The comma is the default separator when you concatenate with the Summarize tool. Clear this field and it will be removed.

 

Concat_without_comma.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Labels