Hi I have 2 excel files as input and need the 3rd file as the output in alteryx designer File 1 Input Column 1ABC File 2 Input Column 2123 Desired Output Required ColumnA1A2A3B1B2B3C1C2C3 #NewbieinAlteryx Regards, Hitesh

build a new file with 2 input excel files

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

File 1

Input Column 1

File 2

Input Column 2

Desired Output

Required Column

#NewbieinAlteryx

Regards,

Hitesh

Developer

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.

You need to have fun with union tool.

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

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