User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
View Translated Thread
JMP2021
JMP2021
Level III

summary function

Created: Feb 15, 2021 11:50 AM  |  Last Modified: Jun 8, 2023 5:28 PM (1676 views)

I noticed the summary function did not category the row correctly when the table is huge this week.

I have one column (e.g. col A) containing very long characters. I try to see how many unique rows per the content of col A. JMP did generate a summary table without any error messages. To my surprise, the sub-table per the summary table still contains some unique rows. Anyone knows why?

0 Kudos
3 REPLIES 3
txnelson
Super User txnelson
Super User

Re: summary function

Feb 15, 2021 12:24 PM (1669 views)  |  Posted in reply to message from JMP2021 02-15-2021
  1. Upper/Lower case mismatches
  2. Double spaces between words for some entries and single spaces for other entries
  3. Preceding or trailing blanks
  4. Non printable characters
Jim
JMP2021
JMP2021
Level III

Re: summary function

Feb 19, 2021 10:54 AM (1572 views)  |  Posted in reply to message from txnelson 02-15-2021

The discrepancy I observed seems like that the criteria used to define matching row by Table summary function is different from that used by selecting matching rows. is this true? If yes, please elaborate the difference.

0 Kudos
txnelson
Super User txnelson
Super User

Re: summary function

Feb 19, 2021 11:04 AM (1570 views)  |  Posted in reply to message from JMP2021 02-19-2021
If you create a new column, baised ono the grouping column in the Summary that is producing the unique rows, and specify the formula
Hex(your column of concern here)
you will be able to compare the exact values for all of the characters in the cells. What you need to do then, is to compare the unique row data with the non unique row and see what the difference is.
Jim

Recommended Articles