Summarize Tool

[bigdaddyvette]

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"

[mbarone]

Can you attach some sample data or screenshots?

[bigdaddyvette]

Data	Color	Employee	Changed	to	Count
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
Should be results	Color	Employee	Changed	to	Count
	Red	A123456	Y	Blue	6
Currenlty
Data	Color	Employee	Changed	to	Count
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
	Red	A123456	Y	Blue	1
Results	Color	Employee	Changed	to	Count
	Red	A123456	Y	Blue	1
	Red	A123457	Y	Blue	1
	Red	A123458	Y	Blue	1
	Red	A123459	Y	Blue	1
	Red	A123460	Y	Blue	1
	Red	A123461	Y	Blue	1

[Qiu]

@bigdaddyvette 

What you mean represent "empty results"?

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

[grazitti_sapna]

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.

Thanks.

[atcodedog05]

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]

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]

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

[bigdaddyvette]

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 · Accepted solution]

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