10751_en-US

liliconcom

No matching columns in limits file<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

I am trying to perform a capability analysis using a limits file, but I keep getting an error "No matching columns in limits file".  I have tried setting it up according to the user guide in "tall" and "wide" formats.  I get the same error either way.  I have the IR control chart set up as follows:

And the limits file set up as follows (data intentionally removed for screen shot):

Anyone know why this error is occurring?  I saw a similar post, but no answers...

Re: No matching columns in limits file

Also, does the Get Limits function work for performing the capability analysis, or just inputs the values for the control charts?

Re: No matching columns in limits file

Thanks Jeff.  I do have multiple measures, so I split the column and then renamed them in the limits table for the different variables.  I had to use a "wide" table instead of "tall" so that I had matching columns for the different measures.  I am not getting the error, but it only seems to be pulling in the mean value, not the upper or lower spec limits.  Not sure why that is, perhaps it is a syntax problem with my labeling?  I am attaching some tables that represent what I am looking at.

Re: No matching columns in limits file

I think that the problem is that you're charting and analyzing a column called Average but you don't have a limits for a column named Average.

For a "Tall" limits table Column 1 should have a row for each column that you want to store limits for, so you'll need a row with "Average" in the first column.

I notice that you've got EDC in the By role and that your column in the Limits table is named EDC that makes me think that you've got some confusion about the By role and the column that you're trying to analyze.

Perhaps you've got multiple measures stored in a single column in your analysis table, with a column, EDC, that specifies what the measure represents.

If so, that structure isn't appropriate for the IR platform with spec limits for Capability analysis. You will probably want to use Tables->Split to separate the measures into individual columns and chart each column. I think your limits table will work better then.

If you could post the data tables, sanitized as appropriate, that you're working with that will make it easier for us to see what you've got and what you're trying to do.

-Jeff

Re: No matching columns in limits file

Though your question was asked in 2015, thought to answer and see if this helps either you or someone else.

 

There are 2 items in the chart. One is control limits and the second is Spec limits. So you have to create two different JMP table (Figure 1 and also attached).

 

First import your spec limits. In this case you can do your capability studies also.

Analyze -> Quality and Process -> Manage Spec limits

 

Select your three parameter in Process and click OK

 

Click "Load from Limits Table" and select the Spec limits file ( I create spec limits with open spec as an example) and then click OK

 

Data gets populated in the table. Then click on "Save to Column Properties". At this stage the spec limits are saved in each column and you can see asterisk sign in your data table.  Click on X to close the window.

 

Now we go to save Control limits. (I renamed the _LimitsKeys from _LSL and _USL to _LCL and _UCL)

Analyze -> Quality and Process ->Control Chart -> IR  

 

 

 

 

 

 

 

 

 

 

Re: No matching columns in limits file

Continue from above

Select three parameter to Process. Click on Get Limits and select the Control LImits. JMP file and then OK

 

Check on Capability box ( to get capability studies)

 

Here you can see the spec limits, control limits and capability studies

 

Re: No matching columns in limits file