Export Properties: XML

The table below describes the properties that can be specified for exports to XML.

Property

Description

GENERAL PROPERTIES

Table

The name of the selected table to be exported.

Export Type

The file type to which your export will be saved.

Export File System

This field describes the file system to which your table will be exported.

  • Local or mounted disk

  • Amazon S3

  • Azure Data Lake Storage Gen2

  • Azure Blob Storage

  • Oracle Cloud Infrastructure

  • Google Cloud Storage

Note: Credentials for cloud-based storage systems can be specified in the Server section of The Application Default Settings.

Export Location

This setting describes where the export file will be saved and what its name will be. Enter the path and name of the export file. You can embed macros (of the form &[macro]) in the file name.

Filter

This setting specifies which filter, if any exist, to apply to the table when it is exported.

When All Filters is selected as a filter option, exports will automatically be named according to the file name.

Sort

This setting specifies which sort, if any exist, to apply to the table when it is exported.

When File Exists

This setting specifies what Data Prep Studio should do if a file with the same name exists in the folder you specified in the Export Location field. Select an action if the export file already exists:

  • Overwrite the file

  • Skip the export operation

Legacy compatibility mode - Ignore format customizations during export

Enabling this option will cause column format customizations to be ignored during the export of numeric and date columns in favor of the following:

Numeric values are exported using the current system's localized decimal separator.

Date values are exported in "yyyy-mm-ddThh:mm:ss" format.
Export All Rows/Limited Rows For tables with defined row limits, this setting specifies whether the defined row limits should be respected during export. Select the appropriate checkbox to instruct Data Prep Studio to export all rows or only those rows that fall within the limit you have set.

SUMMARY-SPECIFIC SETTINGS

Summary 

If the table to be exported is a summary, this setting specifies which summary to include in the export.

When All Filters is selected as a Filter option, you will be unable to select All Summaries as a Summary option. You can select All Summaries as a Summary option by deselecting All Filters as a Filter option and selecting No Filter instead. 

Measure

This setting specifies which measure should be applied to the exported summary.

It is enabled when only a column key is defined in the summary.

Split

This setting instructs the application to create a separate file or table when a distinct value of the first key is encountered in a summary. 

Drill Level

Specifies the drill level to apply to the exported summary. A higher drill level indicates more columns displayed in the output table. 

 

 

 

 

© 2025 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support