Preventing Errors When Model Calculations Use Double Quotation Marks

If you try to open an .mdl-format model containing calculations that include double quotation marks, as might be used to create concatenated categories, you may get an error, even if you followed the recommended practice of wrapping these calculations in single quotation marks.

This is because .mdl-format models do not support the use of single and double quotation marks together, if the ObjectIDOutput flag is set to True, which is the default model creation setting.

To avoid this problem, you have two choices:

• You can open the INI file for the Transformer executable in any text editor, search for the line ObjectIDOutput=1 and change the setting to 0, and then resave your problem model.

• If you must output object IDs, you can use your RDBMS or a tool such as IBM Cognos Impromptu to perform the required calculations, and then import the data into your model.

Whichever strategy you choose, you can then open the .mdl or py?-format model without error.