Simplest way to append a column to existing table?

[tl92]

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!

[MarqueeCrew · Accepted solution]

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

Join on record position. 

[tl92]

Thanks!

[MarqueeCrew]

You're welcome

[Lauta]

---

---

---

You help me too! thank you very much!

[megov31]

Thanks!

[hierde2000]

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?