안녕 @Jeff_Perkinson 당신과 비슷한 내 원래 코드를 사용합니다.
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에서는 작동하지 않습니다.
단순화된 스크립트를 사용하면 올바른 유형의 모델이 생성됩니다.
도와주셔서 감사합니다