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.
SOLVED

Summarize Tool

bigdaddyvette
7 - Meteor

Hello,

 

Can Someone please assist... Im using the Summarize tool to Group 6 Colunms and Count 1. Issue I comming across is one of the colunms represent a Emply number.. example (a123456). When I run report if that number reflect 5 times in that colunm.. instead if in grouping as same number it changing data to a series of numbers example (a123456 then next is a123457 ,a123458,a123459,a123460. and does combine as one and count all with original number of a123456? Hope that makes sense.. Data is set to "String"

9 REPLIES 9
mbarone
16 - Nebula
16 - Nebula

Can you attach some sample data or screenshots?

bigdaddyvette
7 - Meteor
DataColorEmployeeChangedtoCount
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
      
Should be resultsColorEmployeeChangedtoCount
 RedA123456YBlue6
      
      
Currenlty     
DataColorEmployeeChangedtoCount
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
 RedA123456YBlue1
      
ResultsColorEmployeeChangedtoCount
 RedA123456YBlue1
 RedA123457YBlue1
 RedA123458YBlue1
 RedA123459YBlue1
 RedA123460YBlue1
 RedA123461YBlue1
Qiu
20 - Arcturus
20 - Arcturus

@bigdaddyvette 

What you mean represent "empty results"?

I works just alright in my test, unless I am missing something.

Qiu_0-1603927855165.png

Qiu_1-1603927877742.png

 

 

grazitti_sapna
17 - Castor

Hi @bigdaddyvette , as @Qiu  said we are not facing any issues with the dataset you provided and produces the result as expected there might be some whitespace in the values that is treating as separate value. I request you to rather share the workflow you are working on so that we can debug the issues. Please refer to the screenshot.

grazitti_sapna_0-1603948040454.png

 

Thanks.

Sapna Gupta
atcodedog05
22 - Nova
22 - Nova

Hi @bigdaddyvette 

 

Is the data you have provided the complete data. There might be possibility that there are others rows with values ending with 7,8 etc.  You might want to check that.

bigdaddyvette
7 - Meteor

Yes..  Thats was just an example of what Im getting on diff Data... Cant share the real data... but  its whats taking place... which is very odd as Ive used this tool many of times... If i use the example I provided it works for me as well...

bigdaddyvette
7 - Meteor

I attempted to change my Data to Byte then use sum vs count and it cont.. 

bigdaddyvette
7 - Meteor

No Just an example of output I rec on real data.. Ill take a look at other colunms. just weird how Have never had this happen bfr

bigdaddyvette
7 - Meteor

Nevermind... Figured it out.. Raw Data was being saved incorrectlyby others.. My Appolizies for not checking that first.. Thanks to all who Comment to help. Appriciate that

Labels