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": "subdir/file_name.ext",
"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. See filenameRoot property details for more |
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 |