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
binu_acs
21 - Polaris

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

 

binuacs_0-1678488405323.png

 

wonka1234
10 - Fireball

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

binu_acs
21 - Polaris

@wonka1234 I am not getting any error

binuacs_1-1678488641533.png

binuacs_2-1678488659801.png

 

 

 

 

binuacs_0-1678488619335.png

 

wonka1234
10 - Fireball

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

binu_acs
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

 

binu_acs
21 - Polaris

@wonka1234 

 

binuacs_0-1678544933971.png

 

wonka1234
10 - Fireball

@binu_acs  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 .

binu_acs
21 - Polaris

@wonka1234 I was able to run the app

 

binuacs_0-1678547730606.png

 

output

binuacs_1-1678547753984.png

 

 

Labels
Top Solution Authors