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

Question

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

E_Sinha_home · Answer

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?

grazitti_sapna · Answer

@E_Sinha_home  updated workflow with your input.

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

Thanks.

User Input data and join-GS.yxzp

grazitti_sapna · Answer

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

Thanks.