End User Selects Field from an Uploaded Excel Document in Alteryx app

Question

What I am asking may not be possible. I am looking to create and app where the user uploads an excel and then selects what field Account Numbers are in. Unfortunately, the excel files are from different sources so the account number field is always named something different.

I'd like the user to upload the file, identify which field is account number then the app joins the correct data to the account numbers.

I found this on here:

This would work if the file was static, but I need user to upload.

briankuhlmann · Answer

i'll check into chained apps

apathetichell · Answer

Read up on chained apps:

app 1- user selects file.

app 2-  user selects sheet

app 3 - user selects field.

app 4 - data selection?

OTrieger · Answer

One way to do it is having 2 steps in your automation:

Step one getting the data and saved it in to a file

Step two connect that file to a List Box where the user could select the fields.

To do it you will need to have each step in one container and then with  radio buttons enable or disable the step that you would like to process.

In that way when someone running the automation selecting Step 1 the data get saved in the file.
Now the person will run again the automation and this time will select step 2, and he will have the data for selection.

I'm sure that there are more ways to have to do it, this is only one way. and maybe even not the most efficient but will work.