transformations:exportdataset
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:exportdataset [2021/05/08 01:10] – craigt | transformations:exportdataset [2023/11/24 19:41] – craigt | ||
---|---|---|---|
Line 5: | Line 5: | ||
\\ | \\ | ||
=====Description===== | =====Description===== | ||
- | This action exports a dataset (tabular data) into a file in the native EasyMorph format (.dset). The native format allows very fast loading of the data into EasyMorph as there is no data conversion. | + | This action exports a dataset (tabular data) into a file in the native EasyMorph format (.dset) |
One .dset file contains one dataset.\\ | One .dset file contains one dataset.\\ | ||
Line 12: | Line 12: | ||
=====Use cases===== | =====Use cases===== | ||
When working with large datasets that require significant load times, converting the source tables to .dset files and loading those into the workflow can increase overall process performance.\\ | When working with large datasets that require significant load times, converting the source tables to .dset files and loading those into the workflow can increase overall process performance.\\ | ||
+ | |||
+ | Exporting a dataset into a .dset file that is stored on EasyMorph Server or is encrypted can be more secure than saving it into a CSV file or a spreadsheet. | ||
\\ | \\ | ||
Line 33: | Line 35: | ||
|Encrypt columns|When checked, one or more columns in the dataset will be encrypted and require a password to access.\\ | |Encrypt columns|When checked, one or more columns in the dataset will be encrypted and require a password to access.\\ | ||
< | < | ||
+ | |||
+ | \\ | ||
+ | ====Encrypt columns options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Password| Provide the password that will be required to access the encrypted data.| | ||
+ | |Encrypt columns|Select whether to encrypt all columns in the .dset file, or just selected columns (and choose which columns to encrypt).| | ||
+ | |||
+ | \\ | ||
+ | ====Mode options==== | ||
+ | ^Option ^Description ^ | ||
+ | |Create or overwrite|This option will create a new dataset file (if one doesn' | ||
+ | |Append or create|This open will create a new dataset file (if one doesn' | ||
+ | |||
\\ | \\ | ||
- | ====File already exists | + | ====Create or overwrite |
+ | //If a file with such name already exists// | ||
^Option ^Description ^ | ^Option ^Description ^ | ||
|Overwrite|The new file replaces the original file.| | |Overwrite|The new file replaces the original file.| | ||
|Rename|The original file will be renamed with " | |Rename|The original file will be renamed with " | ||
|Halt project execution|The project will stop processing and this action will display a warning symbol.| | |Halt project execution|The project will stop processing and this action will display a warning symbol.| | ||
+ | |||
\\ | \\ | ||
- | ====Encrypt columns | + | ====Append or create |
+ | //If appended data contains new columns// | ||
^Option ^Description ^ | ^Option ^Description ^ | ||
- | |Password| Provide | + | |Add new columns|This option will add columns from the exported file that are not found in the existing dataset file.| |
- | |Encrypt | + | |Ignore new columns |
+ | |Halt project execution|The project will stop processing and this action will display a warning symbol.| | ||
- | \\ | + | \\ \\ |
=====Remarks===== | =====Remarks===== | ||
When importing a dataset (.dset) file with encrypted columns, the [[transformations: | When importing a dataset (.dset) file with encrypted columns, the [[transformations: | ||
Line 51: | Line 70: | ||
If you do not have access to a dataset' | If you do not have access to a dataset' | ||
+ | :!: The encryption password can't be recovered. If it's lost, all the data encrypted with the password will become inaccessible. | ||
+ | |||
+ | \\ | ||
+ | =====Community examples===== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ |
transformations/exportdataset.txt · Last modified: 2023/11/24 20:01 by craigt