Hi @Jeff_Perkinson Verwenden Sie meinen ursprünglichen Code, der Ihrem ähnlich zu sein scheint.
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" )
)
);Dieser funktioniert, um den Modellierungstyp DateTime "Nominal" in JMP14, aber nicht 13 zu erstellen.
Wenn Sie Ihr vereinfachtes Skript verwenden, wird der richtige Modelltyp erstellt.
Danke für Ihre Hilfe