Exporting to a Text File
The Export to Text File task exports datasets or other Rulex structures to a text file.
Drag the Export to Text File task onto the stage.
Connect the task containing the data to export to it.
Double click the Export to Text File task.
Configure the task options as described in the table below in the Options and Export Options tabs.
Save and compute the task.
Export to Text File options
Data to be exported
Select what type data you want to export from the list of options.
Possible options are:
Select how you want to save the file, either by storing it in a location you will then specify (store file), by sending the file as an e-mail (send via email) or both (both).
If you select to send the file by e-mail, you must then specify the e-mail address in the Recipients for export via email edit box.
You can choose between the Saved destinations (which can be set previously at environment level) and the Custom destinations, which have to be set by choosing the type from the drop down menu and clicking the pencil button to insert the details.
Select whether the file will be saved locally (Local File System) or remotely (Http Remote API, Sharepoint, HDFS, AWS S3, FTP, Sftp Server, Azure BLOB Storage). If you chose to save the file remotely on a custom source, you must also configure the Remote Connection parameters in the Remote Connections tab by clicking on the pencil button.
Enter or browse to the directory where the file will be saved.
Enter a name for the text file you want to export.
If not specified, the name of the file will correspond to the upstream task in the flow.
Character coding for output files
Select the character encoding system you want to use:
Add current date and time as prefix
If selected, the date and timestamp will be added to the start of the file basename as a prefix.
Add current date and time as suffix
If selected, the date and timestamp will be added to the end of the file basename as a suffix.
Append data if the file already exists
If selected, the exported data will be appended to the file specified in the File basename option, if it already exists; otherwise the original data will be overwritten.
Recipients for export via email (use comma as separator)
Specify the email addresses where the exported file will be sent, separated by commas.
This option will only be valid if you have selected Send via email or Both in the Mode option.
Select the extension type you require for the exported file.
Possible values are tab, csv, txt or data.
Select the data separator which delimits the values of the data to be exported in the output text file, by selecting comma, tabbing, semicolon, space or by specifying another separator.
String for missing values
Enter the character (or string of characters) which should be used when there are empty values, for example Null or N/A.
Select the symbol used to identify strings. For example, if you select the symbol ” as the text delimiter, age will be exported as “age”.
Put names in line
Specify the line where the attribute names will be saved. Specifying 0 means that the attribute names won’t be exported.
Put types in line
Specify the line where the attribute types will be saved. Specifying 0 means that the attribute type won’t be exported.
Write covering statistics (only for Rules)
If selected covering statistics for rules will be added to the exported text file.
Write error statistics (only for Rules)
If selected error statistics for rules will be added to the exported text file.
Write condition covering statistics (only for Rules)
If selected covering statistics for conditions will be added to the exported text file.
Write condition error statistics (only for Rules)
If selected error statistics for conditions will be added to the exported text file.
Rule format (only for Rules)
Select whether you want the rule data to be expressed as If-then, Matrix, or Multisheet.
If you want to export to a local filesystem, check the dedicated Local Filesystem page.