DEE File Output

note

The transformNAToEmpty property only applies to non-measure output columns (ex: level output columns). To format N/A measure output columns please read the DEE Measure Output Column section.

JSON Structure

"output": {
  "@type": "fileOutput",
  "locale": ,
  "tailoredColumnsHeader": ["Header 1", "Header 2", ...],
  "hasColumnNamesHeader": true,
  "surroundWrittenDataWithQuotes",
  "transformNAToEmpty": false,
  "measureValueIfNull": "",
  "filenameRoot": "whatever_you_want",
  "csvSeparator": ",",
  "maxRowsPerFile": 1000000,
  "maxRawDataSizePerFile": 10737
  "compressionType": "NONE",
  "keepOutputFileIfFailure": true,
  "columns": [
    ...
  ],
  "extractionProcedure": {
    ...
  }
}

Property Details

Property Values Default Value
locale String Locale.getDefault()
tailoredColumnsHeader List of String
hasColumnNamesHeader Boolean True
surroundWrittenDataWithQuotes Boolean False
transformNAToEmpty Boolean False
measureValueIfNull String Empty String
filenameRoot String File Name
csvSeparator String “,”
maxRowsPerFile Integer 1,000,000
maxRawDataSizePerFile Long 1 GiB
compressionType CompressionType: “NONE”, “ZIP”, “GZIP” ZIP
keepOutputFileIfFailure Boolean True
columns List of DEE Output Columns
extractionProcedure Optional extractionProcedure

Compression Types

  • ZIP
  • NONE
  • GZIP