Import Options Missing Variable Flexibility Between Missing Record and Variables

The import options object has the 'MissingValue' rule, but as far as I can tell it's an "all or none" affair, one either fills everything or leaves out a variable or record.

>> opt.MissingRule='omit'
Expected input to match one of these values:

'fill', 'error', 'omitrow', 'omitvar'

The real case often is there are blank records that should follow 'omitrow', but there may also be missing variable values that shouldn't omit the variable for that record but fill

Answer 1

[Piyush Dubey]

Hi dbp,

While defining the import options object, there are multiple parameters that may be directly or indirectly linked with each other and a proper combination of these might help in attaining possible workarounds. ‘omitrow’ and ‘omitvar’ are options that exist and can be followed when an error is committed a particular sort of data type entry (including NULL) can be defined as error. To exercise other use cases different table options can be explored. Documentation for the same are attached below:

https://www.mathworks.com/help/matlab/import_export/importing-tabular-data-into-a-matlab-table-with-customized-options.html

https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html

https://www.mathworks.com/help/matlab/ref/matlab.io.text.delimitedtextimportoptions.html

Hope this helps.