Element Details: Save+Data.CSV
 Back


Available in: Logi Info Source code name: SaveData.Csv

Saves data to an comma delimited (CSV) file.

The file may be used later by another ETL job.

You can reference the number of rows saved in the file with an ETL token.

For Example:
@Etl.mySaveDataID.rdRowCount~



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ColumnNamesInFirstRow
True
False
Set to "true" if the first row of data contains the names of the data columns. Valid descriptions in the first row will override default column names.
CsvDelimiter
UserDefined
The symbol used to separate items in a line of a CSV file. Supports any character or the following special escape sequences: \t = Tab \v = Vertical tab \r = Carriage return \n = Line feed The default is a comma.
DestinationFilename
UserDefined
(Required) The full path and name of the destination file.
EtlElementID
UserDefined
Enter the ID of the Extract or Transform element that contains the data to be processed. If this attribute does not have a value, then the system will use the data from the last Extract or Transform element.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
RowDelimiter
UserDefined
The character or string used to terminate each row of data in a text file. For best results, the character used should not be found within the data. If left blank the default delimiter is a line feed (Lf). Lf = End each line of data with just a line feed (Default). Cr = End each line of data with just a carriage return. CrLf = End each line with a carrage return and line feed.
TextQualifier
UserDefined
If given, then values having this symbol at the beginning and end are treated as text: 1) the text qualifier symbol is removed from the beginning and end 2) if the text qualifier symbol is doubled within the value, it is replaced with a single text qualifier symbol example using single quote as text qualifier: 144, 12/18/2004, 'Lee''s House of Kebab', '719 High Street' 144 12/18/2004 Lee's House of Kebab 719 High Street The default is a quote mark (").
TextQualifierMode
On
Off
Auto
Auto: (Default) If the value contains the delimiter, then the text will be enclosed within the TextQualifier. On: All values will be surrounded by qualifiers. Off: No values will be surrounded by qualifiers.



PARENT ELEMENTS

Click element to drill down for more information.

Etl Job
If
If ETL Error
If File Exists
If Folder Exists Loop.Data Layer Rows


CHILD ELEMENTS

Click element to drill down for more information.

If ETL Error


 Back to top


 Chart Debug