Etlworks Support Help Center home page
What's New? Case Studies Videos Roadmap Blog Free Trial Submit a request
Sign in
  1. Etlworks Support
  2. Tips and Tricks
  3. Working with files

Working with files

Follow New articles New articles and comments
  • 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
© Etlworks LLC | Privacy Policy | Terms of Service Etlworks Support