Dynamically Replacing Fields

[laurennewton]

Hi all, 

I am pretty stumped right now and want to see if anyone is more familiar with the dynamic replace tool. Right now I am building an Alteryx chained app, the first part of this app a user will choose from a predetermined list what field they would like to filter from these are their listed options:

Business Unit
Program
Sub Program Level 1
Sub Program Level 2
Sub Program Level 3
Plant
Project Definition

From here what they chose writes to a placeholder database that stores what they have chosen, see image example below:  (the most important part here is that this is dynamic, one user could choose Business Unit and someone else could choose program and so on)

Now my goal is to now on a separate analytic app show the user all possible business units they can change from see image example below:

I am not sure if I'm overthinking this but the first thought I had was to use the dynamic replace tool which I am struggling with. I have attached the workflow I am working with.

If anyone has ever built an app with such capability or if they are familiar with how to better configure the Dynamic Replace tool that would be much appreciated!

[DavidSkaife · Accepted solution]

Hi @laurennewton 

If i'm understanding your use case then you've really over complicated it :)

This Macro will allow you to dynamically select which field you would like to display the contents of back to the user, and will be able to be easily embedded in an app.

Action Tool config:

Placeholder = Program results:

Placeholder = Business Unit results:

[laurennewton]

Wow I really did overcomplicate that, thank you so much!!