In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Interface tool for Select

Farriyajawed
7 - Meteor

I am trying to get an interface for a select tool where after selecting the file in the app, the user can map the Account and Amount fields to the one in their file. 

 

I have the fields renamed in the workflow but there is a different file every time with different headers and I need them to map Account to Account in their file for the summary tool to work. 

3 REPLIES 3
apathetichell
20 - Arcturus

if feld names change - you'd need to choose chained app.

app 1 -> read in file - see columns.

app 2-> use two dropdowns to map your files.

 

I'd recommend using dropdowns connected to dynamic rename set with:

 

If [_CurrentField_] = "Test" then "Account" else [_CurrentField_] endif (in your dynamic rename set in formula tool -> action tool replaces specific string Test.

 

If [_CurrentField_] = "Test" then "Amount" else [_CurrentField_] endif (in your dynamic rename set in formula tool -> action tool replaces specific string Test.

 

 

 

Farriyajawed
7 - Meteor

Hi, 

Would you have an example workflow of how the chained app are set up with a select tool. I think that would help clarify it. 

apathetichell
20 - Arcturus

Hey - my advice is not to use a select tool. It's to use two dynamic rename tools. Have you built a chained app before? 

Labels
Top Solution Authors