Merging two files to create a table

[Jon001]

Hi,

I hope this is the right place to ask..

I have a requirement to create a table based on two input tables.

table 1 has a single column - account

table 2 has a single column - country

e.g.

Table 1

123

234

345

Table 2

US

AU

CN

What I after is this

new table 3

US	123
US	234
US	345
AU	123
AU	234
AU	345
CN	123
CN	234
CN	345

If I was using excel this is a simple thing, but I cannot work out how to do this in Alteryx

I am assuming it is simple but I must be missing something. 
thanks

[atcodedog05 · Accepted solution]

Hi @Jon001 

This can be achieved using append tool.

Workflow:

Hope this helps : )

[Jon001]

That’s perfect. I knew there must be a simple way. I was going down rabbit holes. 
thanks very much 

[atcodedog05]

Happy to help : ) @Jon001 

Cheers and have a nice day!