Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Alteryx Summarize tool doesn't give error when field is not in source & used to summarize

KeyMaker
6 - Meteoroid

Alteryx is not giving an error when field is not present in source and use it for any summarized max, min, avg, sum,  functions.

Alteryx will throw an error when field is not present in source, but used in Group by Action.

 

This cause unexpected results. please find attached workflow where green container gives me correct results versus red one is not.

In summary, Alteryx must throw an error when field is not in present in Fields section which produce unexpected results. 

 

 

in below example Building field is not even present in fields but there is no error. 

expected value of summary tool was 

KeyMaker_5-1653435440277.png but because there is no error, Alteryx is giving below which is count than i wanted is sum of pre-calculated field.

KeyMaker_6-1653435464629.png

 

 

 

KeyMaker_4-1653435368815.png

 

 

 

 
 

 

 

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@KeyMaker 
Basically on my test, there is an exclamation mark mark on the icon of Summarize Tool and there is an error message also showing when I run the flow.
Just in case, can you your setting on "Disable Auto Configure" in the user setting menua?

 

SummarizeToolError.png

KeyMaker
6 - Meteoroid

Thanks. Did you able to open my workflow with example ?

 

I think your example has City as Group by.

 

Use City Field  like count(City) instead of group by and remove City field from source fields. it won't give an error.
1. Add City Field

2. Count (City)

3. Remove City from source fields and run flow. 

Labels