Salut @Jeff_Perkinson en utilisant mon code d'origine, qui semble similaire au vôtre.
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" )
)
);Celui-ci fonctionne pour rendre le type de modélisation DateTime "Nominal" dans JMP14 mais pas 13.
Lorsque vous utilisez votre script simplifié, cela fonctionne, il crée le bon type de modèle.
Merci de votre aide