Using the interface tools to pick the fields that should be mapped in a select tool

I've been playing around with the interface tools and the select tool and can't get something working, which I imagine is possible but would like some help/input into getting a solution.

Problem:

For different input files (but each file would broadly have similar data in) I need to rename certain fields so they will pass through to a Tableau dashboard. As each input file may be in a different language or field name headings may vary slightly and/or the order of the fields may be different per client, I need a way to update the way the select tool is working through a user interface.

An example of the current select tool set up is below:

What I want the solution to be able to do:

What I would like to have is a set of drop down boxes using the interface tools, which enable the user to pick the fields in the input file and map these to the corresponding required fields for the Tableau input.

A mock up would look like this (assuming the translation to French works):

So any pointers or help from the Community would be greatly appreciated.

Apps

Preparation

Accepted answers

BenMoss

In that instance you need to set up the config to read the meta data from the file browse, like in this image.

Interface Config.png

All comments

BenMoss

This is definitely possible and is something I have done myself end to end.

Please find the attached configuration, this is all about the actions used to overwrite the placeholders that exist in the initial dataset.

Ben

Macro Map Fields.yxzp

LordNeilLord

Hey @cgoodman3

I think you need a setup like this:

Changing Columns.PNG

ChangingColumns.yxzp

cgoodman

Hi Ben

Are you able to share screenshots or share a version created in an earlier version of Alteryx, my employer has only recently got us onto 11.5 and I get an error to say the packaged file has been created in a newer version.

Thanks

Chris

cgoodman

Hi @LordNeilLord

Thanks that is along the lines of what I was after, however if I change the input file using the browse to file interface tool, then in the analytic app GUI it doesn't refresh the field names based on the new file it as it still reads them in from the input file "Sample - EU Superstore". To do that would it need to be broken into two stages: (1) to get the field names which go into the drop down box and (2) update the select tool?

Thanks in advance.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703