We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Creating Summarization Analytic App - Duplicate Grouping field error

wonka1234
10 - Fireball

Hi,

 

I'm having trouble creating this analytic app to summarize values.

 

wonka1234_3-1678486219060.png

 

 

wonka1234_0-1678485419366.png

 

wonka1234_2-1678486156729.png

I believe it is due to duplicates in this xml area but i am having difficulty troubleshooting. Is it because treeinput is repeated 4 times?

 

If I use a text input instead of the formula tool, this works fine.

 

This works fine and produces the correct result - 

 

wonka1234_5-1678486396257.png

 

 

Idea is from https://community.alteryx.com/t5/Alteryx-Designer-Discussions/App-allowing-users-to-manipulate-the-s...

 

any help is appreciated.

 

 

12 REPLIES 12
binuacs
21 - Polaris

@wonka1234 I am able to run the app, which options gives you the error

 

binuacs_0-1678488405323.png

 

wonka1234
10 - Fireball

@binuacs  for example im trying to  group by "First Name" and sum "amt". And getting the error in the screenshot.

binuacs
21 - Polaris

@wonka1234 I am not getting any error

binuacs_1-1678488641533.png

binuacs_2-1678488659801.png

 

 

 

 

binuacs_0-1678488619335.png

 

wonka1234
10 - Fireball

@binuacs  what do your results show? this is bizarre.. I want to see the result after the data aggregation macro (black and white one)

binuacs
21 - Polaris

@wonka1234 below is what I see

 

binuacs_0-1678489240396.png

 

wonka1234
10 - Fireball

could you put an output tool here and show me what your getting?

 

wonka1234_0-1678489442454.png

 

binuacs
21 - Polaris

@wonka1234 

 

binuacs_0-1678544933971.png

 

wonka1234
10 - Fireball

@binuacs  can you put an excel output and run it as an analytic app. Group by name and sum on amt.

It runs fine in designer mode but i am trying to make an app .

binuacs
21 - Polaris

@wonka1234 I was able to run the app

 

binuacs_0-1678547730606.png

 

output

binuacs_1-1678547753984.png

 

 

Labels
Top Solution Authors