How to dynamically summarize a field in alteryx

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 .

Server

Interface Tools

Accepted answers

RSreeSurya

Attaching the updated workflow, please have a look.

Let me know in case of any challenges.

Dynamic Summarize.yxzp

RSreeSurya

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

Thanks.

All comments

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.

Dynamic Summarize.yxwz

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

Attaching the updated workflow, please have a look.

Let me know in case of any challenges.

Dynamic Summarize.yxzp

RSreeSurya

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

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703