Create an app that takes up user input data and joins them with a primary key

[E_Sinha_home]

Hello

I am trying to create an analytical app.

Scenario :

I have 100 files (File Names: F1-F100) in a folder with "SerialNo" as the primary key for all files.

My app will let the users select the name of the file they want to join together (eg: F1,F5,F7)

The app will then pull all the 3 files and join them with the primary key SerialNo and produce the output.

How can this be done?

Thanks

[grazitti_sapna]

Hi @E_Sinha_home , can you provide a sample dataset and expected output for better clarity?

Thanks.

[E_Sinha_home]

Hey

I have created a dummy data set with 4 tables (F1-F4).

Now if the user chooses F1,F2,F4, the output i desire is also attached herein.

Thanks heaps in advance!

[grazitti_sapna]

Hi @E_Sinha_home , I have prepared a mock workflow I hope it helps.

Thanks.

[grazitti_sapna]

@E_Sinha_home  updated workflow with your input.

I hope it works, and if it does kindly mark this post as solution.

Thanks.

[E_Sinha_home]

Hey 

Thanks for this. Now what if a user selects just F1 and F3?

Also

The user will just type in F1/F2/F3 and so on.. so that would be a text box (or a List Box)

Secondly, the user can select any number of files to join.

How to incorporate that?