Alteryx Designer Desktop Discussions

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

Interactive tool

Inactive User
Not applicable

Hi, team. 

I have 3 columns: Name, Number and Description in the file. 

I need to select the Name and Description, so that I need to get the sum of column Number respective to the name and description. 

 

Suppose if I select Name, and select the description then I need to get the sum of number which is related to the name and description

 

Please help. 

It need to be done in interative tool because we need to select the name and description to see the number column

7 REPLIES 7
DataNath
17 - Castor
17 - Castor

How does this look @Inactive User? Hopefully I've understood the ask correctly. The Summarize tool sums all combinations of Name + Description and then the app allows you to pick which Name and Description you want to see the sum of:

 

DataNath_0-1656925534220.png

 

Inactive User
Not applicable

Thanks @DataNath I will go through and let you know. Thank you so much

Inactive User
Not applicable

Hi, @DataNath I tried to apply samething but i am not getting it. 

Could you please help me with the same this to the below data. Please. Thank you.

DataNath
17 - Castor
17 - Castor

Hey @Inactive User looked like the [Name] field in the original data sample you provided had a space in it so wouldn't read properly when you added the new data in. I've updated the app now. Will users know which descriptions belong to which names? At the moment all descriptions will show, rather than only relevant values as the app isn't chained. Let me know how this is.

Inactive User
Not applicable

Sure @DataNath Thanks a alot

 

Inactive User
Not applicable

@DataNath hi, I am not getting out put in this cross tab. It has input but when I run the workflow it does not have any output. Please help

Thatiparti_0-1656935319613.png

 

DataNath
17 - Castor
17 - Castor

Hey @Inactive User there shouldn't be any output there. The top two streams including the Summarize and Cross-tab tools are just there to dynamically populate your dropdown options. I thought the point of the request was user-selected filtering and so this should be ran as an app, rather than as a workflow itself. If you hit the magic wand button and run it as an app, is that what you're after?

 

Run as app.png

DataNath_0-1656935787747.png

 

Labels
Top Solution Authors