Working with files
- Work with local files
- Use server storage as a staging area
- Process files in a folder by a wildcard filename
- Process the file and then delete it
- Read and write files from/to specific folder using the same Connection
- Read from and write into different Excel worksheets using the same Excel Format
- Read from and write into different worksheets using the same Google Sheets Connection
- Group rows in Excel XLSX worksheet
- Filter rows in a flat file
- Append rows to the existing file
- Disable automatic setting of the field data type when working with files
- Work with very large files
- Merge CSV or XML files
- Read non-standard CSV files
- Preserve the exact data types when extracting data from a database and creating the CSV files
- Split a CSV file when creating it
- Add a custom header to a CSV file
- Disable encoding CLOB fields in CSV files
- Configure XML parser
- Read an Excel worksheet with a header, not in the first line
- Use an Excel worksheet index when reading Excel workbooks
- Work with region-specific S3 buckets
- Archive files before copying them to a cloud storage
- Add metadata when creating files in S3 and Google Storage