Get Unique Values

[#1]

Purpose of the tool is to provide user-interface with unique values listed from selected column (nominal, ordinal) in different formats from selected datatable. From this list user can either directly copy-paste values to clipboard or use specific buttons for copying.

Tool also provides an option to paste values directly to the box and get the values in different formats. This is handy when you copy paste values from excel for example. You can also format values from clipboard directly to SQL list.

Example how tool looks with JMP's Semiconductor Capability dataset with JSL_Char_list and missing values hidden:

Current options

Type selection

• JSL_Char_list - will show values as JMP List
• JSL_aa - will show values as JMP Associative Array with value being count of unique values

Remove Missing

• Hides missing values from window

Buttons

• SQL String
  • Copies values from selected column to clipboard as sql in with characters: ('lot01_01', 'lot02_02')
• SQL Numeric
  
  • Copies values from selected column to clipboard as sql in with numbers: (123, 456, 567)
• JMP List
  
  • Copies values from selected column to clipboard as JMP List: {"lot01_01", "lot01_02"}
• JMP AA
  
  • Copies values from selected column to clipboard as JMP Associative array ["lot01" => 120, "lot02" => 120]
• Window To SQL
  • Copies values from seen script editor box as SQL list. Can be used for example to copy paste values from Excel to window to get SQL in formatted string
• Clipboard to SQL
  • Copies values clipboard as SQL list.

You can post improvement ideas here here or in open issue in GitHub - Get Unique Values .

This tool is part of JMP-Tools I have been working on for some time now and I will release more Add-Ins when time permits in JMP Community.