Update column names in Join tool using Alteryx analytical app

Question

Hi,

I am trying to create an analytical app which will give the users an option to enter the fields they would like to be joined in the join tool. I tried using text box and action tool combination however it does not update the columns, it can only update string fields or values in formula or filter tool. Can you please help me understand if it is even possible to update columns using analytical app fucntionality.

Sample workflow.yxwz

JoeS · Accepted Answer

The part missing is selecting the bit you want to update in the action tool

Here you can see the part you had selected (in blue) was the tool itself, the part that you want to update is the configuration of the join field.

It should look like:

However, to get there you had to do a couple things...

Which leads me to a best practice point I'll always mention to anyone.

The first thing to do when building any app it so build a working workflow first.

So I went and added in a file to each input, updated the join tool to join on two fields.

I then went a little further and added a file browse for each input and the action to update them.

I also changed the text box's to drop downs and populated them from the files the users selects, as for me allowing a user to enter free text for a field is asking for trouble.

Added a couple of labels, leaving the final interface looking like:

The app is attached, I went through things very quickly above. Let me know if there is anything not clear.