Best way to concatenate fields names/crate join key, in an alteryx APP

[wonka1234]

Hi,

I am trying to create a tool that will allow the user to browse files, concatenate headers, thus creating a  join key, then join on this key.

Is this possible to do? 

In designer it would be something like using the formula to create a new field and just do : Field 1 + Field2 + Field3.

Can this somehow be replicated in an analytic app so it can be exposed on the server?

Thanks.

[Robin_McIntosh]

@wonka1234  Now, if the headers were the same across all files, then you could set that up within the workflow to feed into the List Box and not have to do a chained app.  One idea is to have a full list of the different headers (if you have say small handful of different variations) and then the user would just need to make sure the header(s) they choose are part of the input file they select.

Example where I have an Excel file with different header names.  The List Box automatically grabs the data from this file to populate the List Box in the app.  No chained app needed.

  

[wonka1234]

@Robin_McIntosh 

could i use this option?

update field list through this way? Or must it be external file?