Hola @Jeff_Perkinson usando mi código original, que parece similar al tuyo.
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" )
)
);Este funciona para hacer el tipo de modelado "Nominal" DateTime en JMP14 pero no 13.
Cuando usa su script simplificado, funciona, crea el tipo correcto de modelo.
Gracias por tu ayuda