.Stat Suite documentation

Delete data or referential metadata

Version history:
Support full delete actions for data and referential metadata with July 4, 2023 Release .Stat Suite .NET ‘dragonfruit’ Delete values since September 22, 2022 Release .Stat Suite .NET ‘blueberry’

Deleting values:
Full observations (with their measure and obs-level attribute values) as well as individual observation or attribute values can be deleted with the D(elete) action with SDMX-CSV version 2.0 or SDMX-ML file formats. For more information see Delete data with an SDMX-CSV or SDMX-ML (xml) file.

Referential metadata attributes at partial coordinates as well as individual referential metadata attribute values can be deleted with the D(elete) action with the SDMX-CSV version 2.0 file format. For more information see Delete referential metadata with an SDMX-CSV file.

It is also possible to “transfer” (copy) the deletion of data and reference metadata from one data space to another. The following scenario does thus work:

  1. User loads data and reference metadata into a Space A
  2. User transfers all data and reference metadata from Space A to Space B (without filter)
  3. User deletes data and/or reference metadata in Space A
  4. User transfers all data and reference metadata from Space A to Space B (without filter, optionally using updatedAfter for higher performance)

–> This will delete also all those data and/or reference metadata in Space B that have been previously deleted in Space A.

Nulling values:
The SDMX-CSV version 1.0 messages will now systematically use the M(erge) action, which changes its upload behaviour: Empty measure or attribute column cells will not lead anymore to deleting (nulling or setting to null) the related values in the database. Observation, attribute and referential metadata attribute values can be deleted (nulled) only by using the R(eplace) action with the SDMX-CSV version 2.0 or SDMX-ML file formats by leaving those values empty. This method does not allow completely deleting observations and reference metadata attachments.

Alternatively, individual observation, attribute and referential metadata attribute values can be deleted (nulled) using the D(elete) action with the SDMX-CSV version 2.0 or SDMX-ML file formats, see above. When all related measure and attribute values for the given (partial) key have been deleted (nulled), e.g., through successive D(elete) actions, then the related observation or reference metadata attachment is completely deleted.

Intentionally missing values:
After a special data structure configuration, a specific syntax can be used for intentionally missing values of the numerical types float and double (NaN) and of all textual types (#N/A). For more information see Intentionally missing values.