Dynamically update a formula based on user selection

OscarM

Hi there,

I'm a newbie with Alteryx, currently attempting to build a workflow app that complete the following activities: 

1) User upload a file (*.xlsx file)

2) User to select a column within that file

3) For the selected column, the workflow dynamically applies a formula on that column. (In this use case, the formula would change the last 4 digits/letters of the selected column into "XXXX", thus creating a masking element)

4) File output.

So far, I am able to complete 1) and 2), and currently stuck in 3). Does anyone know how we can configure the workflow to allow the formula input tool to be updated based on the column selected by the user? 

Thanks for all your help!

grossal

Hi @OscarM,

it was actually a bit trickier than expected, but I got closer to your solution:

The Text Box allows you to pick the column that should be masked. I had to use the 'Update Raw XML with Formula' option in the Action tool. The Interface looks like this:

I also tried a Multi-Field-Formula, but you can't use your Input List for it because it is set to "Select Tool Mode" instead of Custom Generated List.

I'll try to switch the Select tool with a Dynamic select and tell you if I got some improvements. Current version attached.

Best

Alex

2020-08-06-Update Raw XML with Formula.yxwz