build a new file with 2 input excel files

[HiteshChandwani]

Hi I have 2 excel files as input and need the 3rd file as the output in alteryx designer 

File 1 

Input Column 1

A

B

C

File 2 

Input Column 2

1

2

3

Desired Output

Required Column

A1

A2

A3

B1

B2

B3

C1

C2

C3

#NewbieinAlteryx

Regards,

Hitesh

[Emil_Kos]

Hi @HiteshChandwani,

You need to have fun with union tool.

Please see a configuration of this union tool and make something similar. 

[HiteshChandwani]

Hi Emil,

Thanks for the reply 
the suggestion you gave just lists out all the values in both the sheets 
however what i am looking for is 

for each value in sheet 1 

list values of sheet 2 with the prefix of value from sheet 1 

in sheet 3

Thanks in advance.

Regards,

Hitesh

[Emil_Kos · Accepted solution]

Hi @HiteshChandwani,

My bad. I was able to replicate the desired output table. 

They are not in the separate sheets but you will have a needed column.

[HiteshChandwani]

was able to get it resolved using append and generate rows 

thanks for your time 🙂

[Emil_Kos]

@HiteshChandwani 

Happy that you made it work 🙂