export

Overview
The export statement is used to snapshot the data in a DSET and write it to disk as a Dataset.
Syntax
exportsource.aliasasfilename
Details
The exported file will be created under <base_dir>/exported. The filename parameter may include a path as well as the filename to export, so long as it does not contain the substring ".." and is not an absolute path. If the path contains one or more directories that do not exist then they will be created.
Exporting usage
The source.alias argument is the DSET ID to export (see Core concepts for more information on DSET IDs).
The export statement can be used at any point during this process to save a CSV (conforming to Dataset format) which snapshots the data in the DSET at that moment in time. This can be used for a number of purposes including:
Examining the state of data part-way through processing for debugging purposes
Creating custom exports for subsequent import into 3rd part systems
Producing output CSV files (which may potentially contain merged data from multiple sources) for subsequent processing with another Transcript
Examples
When specifying a Windows path it is advisable to use UNIX-style forward slashes as the path delimiters, or to put the path+filename in double quotes to avoid occurrences of\t being interpreted as a TAB character
The following Transcript will import a quoted CSV file, add a ProcessedFlag column to it with a value of 1 in each row, and save it back out again without quotes:
1
option quote = \"
2
use usage from azure
3
create column ProcessedFlag value 1
4
option noquote
5
​
6
# Will be exported as <basedir>\exported\azure\flagged.csv
7
export azure.usage as "azure\flagged.csv"
Copied!

event_to_usage

finish

Last modified 2yr ago

Export as PDF

Copy link

Contents