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 123234345 Table 2 USAUCN What I after is this new table 3 US123US234US345AU123AU234AU345CN123 CN234 CN345 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

Merging two files to create a table

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

What I after is this

new table 3

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

Output

This can be achieved using append tool.

Workflow:

Hope this helps : )

This can be achieved using append tool.

Workflow:

Hope this helps : )

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

Happy to help : ) @Jon001

Cheers and have a nice day!