Multiple Response error

[#1]

Hi All,

I have a data file which keeps giving me the error: "The Multiple Response column property is not appropriate for a column with the Numeric data type."

I have checked all of my MR columns and they were all set to "character".  I still received the error, so I deleted the MR columns completely and saved the file -- still same error. I then checked the "column info" for EVERY column and found one column that had MR in the column property which shouldn't have been there. Net, I deleted that column completely and resaved the file, but still get the same error.

The log shows: "Unknown format: Character", but does not tell me which column is causing the issue.  How can I identify the problem column?

Thank you!

Erica 

[#2]

You might try Cols > Column Viewer with the data table open. Select all of the columns in the table, Click the column properties button to filter.

I am not sure that this will help. You have tried all the right things. The fact that it keeps showing the error suggests that you might contact JMP Technical Support (support@jmp.com) to see what they know. Please reply here if you get an answer.

[#3]

Hi Mark,

Thank you!  Column Viewer enabled me to find the columns causing the issue, however, none of them show "Multiple Response" in their column properties.

I've deleted most of the columns in the file so it is easy to see the ones causing the issue (Question 1-11).  I've tried using "Standardize Attributes" to change the "modeling type" a couple of times just to see if that would reset something...  but, they still show as MR columns in the Column Viewer.  Any thoughts on how I might correct this (i.e. clear "MR" from these columns)?  I've attached the file below.

Thanks,

Erica

[#4 · Accepted solution]

You could script this and loop over the columns while deleting Multiple Response column property

Names Default To Here(1);

dt = Current Data Table();

For Each({col_name}, dt << Get Column Names("String"),
	show(Column(dt, col_name) << Get Property("Multiple Response"));
	Column(dt, col_name) << Delete Property("Multiple Response");
);

You can also remove these by using Standardize Column Attributes (at least this worked for me):

1. Select all weirdly behaving columns

2. Open Standardize Column Attributes and delete Multiple Response column property

It might also be a good idea to contact JMP Support about this. This can be easily replicated (Using JMP16.2 Pro on Windows):

1. Create table with Character column with numeric values

2. Set Multiple Response Column property

3. Change data type to numeric and modeling type to nominal

4. Now you have Numeric column with Multiple Response set

5. Go back to the column menu and change Data type back to Character

6. Close column menu and reopen it. Multiple Response will be visible again

[#5]

Hi there,

Thank you - that was my issue!  I had Multiple Response column properties, but could not see them since the column was set to numeric.  I used your suggestion of Standardize Attributes to remove the Multiple Response column property.

Again, thank you!

Erica

[#6]

Could you please attach the JMP file so we can have a look?  Screen shots of the error don't help diagnose the cause of the problem.  The data type needs to be set appropriately (see the attached JMP data set where Brush Delimited is MR)