Combining multiple files together

Question

Hi

I need to create an user interface that comes with a drop down containing file names.

The user will select the files he need to join together (any number of files) and hit run.

Note : All files have the same primary key.

The Alteryx app will let me join all the selected files with that primary key and give me the output.

Will this be possible?

G03.xlsx

G01_A.xlsx

G01_B.xlsx

G02.xlsx

OUTPUT.xlsx

Kenda · Answer

Hi @E_Sinha_home

Will you always have the same number of files that you need to join together?

Attached is a sample workflow that requires 4 files, as in your example.

e sinha home.yxzp

TrevorS · Answer

Hello @E_Sinha_home

Can you please attach any progress you have made with this so far?
Additionally,  maybe one of our ACEs may be able to assist.

@Kenda @patrick_digan could either of you assist?

Thanks!

Trevor