Alteryx Designer Desktop Discussions

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

Simplest way to append a column to existing table?

tl92
6 - Meteoroid

I just wanted to ask if there is a simple way to append a one-column table which I have generated, to another table with the same number of rows. I feel like there should be a simple way to do that, but I always need to use several tools to get to the result.

 

If it were rows, I could just use the union tool to append the row below the table. Is there a way to move a column "up" or "down" with the union tool, instead of just "left" and "right"? Or is there another tool/simple workflow which can easily achieve this?

Example:

Existing table:

 

1 | 4

2 | 5

3 | 6

 

Want to append following column to the right of table:

 

7

8

9

 

So that final result is:

 

1 | 4 | 7

2 | 5 | 8

3 | 6 | 9

 

Thanks in advance for your help!

 

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus

Yes. Use the join tool and instead of using the second option in the configuration, use the first. 

 

Join on record position. 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
tl92
6 - Meteoroid

Thanks!

MarqueeCrew
20 - Arcturus
20 - Arcturus

You're welcomeMan LOL

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Lauta
5 - Atom



You help me too! thank you very much!

megov31
7 - Meteor

Thanks!

hierde2000
5 - Atom

Hi, 

 

the join function seems to have evolved in the latest version of Alteryx and this doesn't work anymore. I end up with all the values in the same field. 

 

How can you do it in the current version? 

Labels