やあ@ジェフ・パーキンソンあなたのコードに似ている私の元のコードを使用してください。
path = Get Default Directory();
dt = Pick File("Select .csv file with data", path, {"Excel|csv;xlsx;xls", "JMP Files|jmp;jsl;jrn", "All Files|*"}, 1, 0, "");
Open(dt,
columns(
New Column( "DateTime",
Numeric,
"Nominal",
Format( "y/m/d h:m"),
Input Format( "y/m/d h:m:s", 3 )
),
New Column( "NSR_ID", Character, "Nominal" ),
New Column( "TaskId", Character, "Nominal" ),
New Column( "TaskType", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "TaskCreateTime",
Numeric,
"Continuous",
Format( "y/m/d h:m:s", 26, 3 ),
Input Format( "y/m/d h:m:s", 3 )
),
New Column( "RecipeFile", Character, "Nominal" ),
New Column( "PureRecipeFile", Character, "Nominal" ),
New Column( "Product", Character, "Nominal" ),
New Column( "Layer", Character, "Nominal" ),
New Column( "LotLabel", Character, "Nominal" ),
New Column( "PureLotLabel", Character, "Nominal" ),
New Column( "Reticle1", Character, "Nominal" ),
New Column( "IllumId", Character, "Nominal" ),
New Column( "ResultFile", Character, "Nominal" ),
New Column( "ExpLogName", Character, "Nominal" ),
New Column( "AtmPres", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "AtmPresTime",
Numeric,
"Continuous",
Format( "y/m/d h:m:s", 26, 3 ),
Input Format( "y/m/d h:m:s", 3 )
),
New Column( "WCt", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "RepCt", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "AFZType", Character( 1 ), "Nominal" ),
New Column( "MeasPos/X", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "MeasPos/Y", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "MeasPos/Rot", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "MeasPos/Z", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "MeasPos/TiltX", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "MeasPos/TiltY", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "MeasMode", Character( 1 ), "Nominal" ),
New Column( "ScanVelocity", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "ScanLength", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "ScanDirection", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "ScanNum", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "MeasAveTime", Character( 1 ), "Nominal" ),
New Column( "AsocPk", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "RefMeasDate", Character, "Nominal" ),
New Column( "WTD_Z", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "IF_Roll(ZF1)", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "IF_Pitch(ZF12)", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "IF_AF-Z(Ave_ZF12)",
Numeric,
"Continuous",
Format( "Best", 12 )
),
New Column( "IF_AIS-Z(ZB3)", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "IF_AIS-Z(ZB3_Abbe)",
Numeric,
"Continuous",
Format( "Best", 12 )
),
New Column( "IF_ZF1", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "IF_ZF2", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "IF_ZF12", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "IF_ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "Roll_ZF1", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "Roll_ZF2", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "Roll_ZF12", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "Roll_ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "Pitch_ZF12", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "Pitch_ZF1ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "Pitch_ZF2ZB3", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "RetryCount", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "WaterRefInterp", Character, "Nominal" ),
New Column( "OK/NG", Character, "Nominal" ),
New Column( "G-ASOC_AFZ", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "WFMsens_Ave", Character( 1 ), "Nominal" ),
New Column( "Ave", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "TiltX", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "TiltY", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "CurveX", Character( 1 ), "Nominal" ),
New Column( "1", Character( 1 ), "Nominal" ),
New Column( "2", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "3", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "4", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "5", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "6", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "7", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "8", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "9", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "10", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "11", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "12", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "13", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "14", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "15", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "16", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "17", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "18", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "19", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "20", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "21", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "22", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "23", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "24", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "25", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "26", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "27", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "28", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "29", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "30", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "31", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "32", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "33", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "34", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "35", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "36", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "37", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "38", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "39", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "40", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "41", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "42", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "43", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "44", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "45", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "46", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "47", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "48", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "49", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "50", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "51", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "52", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "53", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "54", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "55", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "56", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "57", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "58", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "59", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "60", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "61", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "62", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "63", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "64", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "65", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "66", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "67", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "68", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "69", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "70", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "71", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "72", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "73", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "74", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "75", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "76", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "77", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "78", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "79", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "80", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "81", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "82", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "83", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "AtmPres 2", Numeric, "Continuous", Format( "Best", 12 ) ),
New Column( "AtmPresTime 2",
Numeric,
"Continuous",
Format( "y/m/d h:m:s", 26, 3 ),
Input Format( "y/m/d h:m:s", 3 )
),
New Column( "AtmPresTimeDelta",
Numeric,
"Continuous",
Format( "Best", 12 )
),
New Column( "AtmPresEventID", Character, "Nominal" )
),
Import Settings(
End Of Line( CRLF, CR, LF ),
End Of Field( Comma, CSV( 1 ) ),
Strip Quotes( 0 ),
Use Apostrophe as Quotation Mark( 0 ),
Use Regional Settings( 0 ),
Scan Whole File( 1 ),
Treat empty columns as numeric( 0 ),
CompressNumericColumns( 0 ),
CompressCharacterColumns( 0 ),
CompressAllowListCheck( 0 ),
Labels( 1 ),
Column Names Start( 1 ),
Data Starts( 2 ),
Lines To Read( "All" ),
Year Rule( "20xx" )
)
);これは、JMP14 では DateTime を "公称" モデリング タイプにするために機能しますが、13 では機能しません。
簡略化されたスクリプトを使用すると、正しいタイプのモデルが作成されます。
ご協力ありがとうございました