How to dynamically summarize a field in alteryx

[desmond99890]

i am  trying to create an alteryx application in which i am using interface tools to allow the user to locate the file in the system and then in the data file i will be having industry names in a column and i want the summarise tool to take that column and summarise concatenate the industry names .

[FrederikE]

Hey @desmond99890,

What is the dynamic part of this (besides reading in the sheet)? Also, where are you stuck? Your approach seems fine to me.

[RSreeSurya]

Hi,

Please find the attached Analytic app. 

Below is the user interface for the Analytic app, users can select from the drop down , which column to use in the summarize tool to concatenate. Fields which are available in the input stream will dynamically appear here. Here I have taken Industry, industry2 and industry 3 as sample. 

Once Selected based on the field selected, data is concatenated.

Input: 

Output when Industry is selected:

Output When Industry 2 is selected:

Output when Industry 3 is selected: 

Hope this helps and this is the output you are looking for.

[desmond99890]

it does work fine and fullfills the objective but i want the user to input the excel file which contains list of industries during run time here u have hardcoded it in the textinput tool. 
 i tried this but getting error

[desmond99890]

the summarise tool needs fields before execution and i want it to take during run time automatically.

[RSreeSurya · Accepted solution]

Hi 

Attaching the updated workflow, please have a look. 

Let me know in case of any challenges. 

[RSreeSurya · Accepted solution]

If the workflow fulfills the requirement, please mark it as a solution for the problem 

Thanks.