Append single row table to table columns

[ChrisMB]

I try to accomplish the follwing in my Alteryx workflow:

Table 1 (multiple rows):

1 | A

2 | B

3 | C

4 | D

5 | E

Table 2 (single row):

ABC | DEF

These two tables should be combined in the following way:

1 | A | ABC | DEF

2 | B | ABC | DEF

3 | C | ABC | DEF

4 | D | ABC | DEF

5 | E | ABC | DEF

I tried using a combination of the Join tool and the Multi Row Formula tool, but this does not give the desired outcome. Any tips here?

[MarqueeCrew · Accepted solution]

Use an append fields tool. It will work like magic!

[ChrisMB]

I feel really stupid that it was that simple. Works like a charm indeed, thanks!

[MarqueeCrew]

It seems like there is generally an easy answer. The community is here to help.

Cheers,
Mark