¶ Description
Read Belgium bank CODA files.
¶ Parameters
Parameters:
- Input file:
- To extract:
- Output filenames in additional column:
- Minimum Input file size:
¶ About
This action reads Belgium bank CODA files, which are standardized electronic banking statements used by Belgian banks. It can parse and extract different parts of these files for further processing in ETL pipelines.
¶ Parameters
| Parameter | Description |
|---|---|
| Input file | The CODA file to be read. You can select from sources like shared files, assets, or recorded data. |
| To extract | Specify which sections of the CODA file to extract: - header + old balance (0_1)- header + old balance + data record (0+1+2=3)- header + new balance (0+8)- header + free communications (0+4)- header + trailer (0+9) |
| Output filenames in additional column | Toggle to include the filename in an additional output column. |
| Minimum Input file size | Set a minimum file size (in MB) to process files, avoiding empty or invalid files. |
¶ Extraction Options (To extract parameter)
| Option | Details |
|---|---|
header + old balance (0_1) |
Extracts the header and old balance sections of the file. |
header + old balance + data record (0+1+2=3) |
Extracts header, old balance, and data records—most detailed option for full transaction data. |
header + new balance (0+8) |
Extracts header and new balance information. |
header + free communications (0+4) |
Extracts header and any free text communications. |
header + trailer (0+9) |
Extracts header and trailer sections—useful for summary or control purposes. |
¶ Typical Use Cases
- Banking Statements Import: Parse CODA files from banks to automate bookkeeping or financial reconciliations.
- Financial Reporting: Extract transactions and balances for reporting and audit purposes.
- Transaction Monitoring: Automate detection of specific transactions via data record extraction.
- Accounting Integrations: Use with accounting software or custom financial databases for automated imports.
Notes
- The CODA format follows a strict standard; this action helps extract exactly the sections you need.
- Works well combined with data filtering and reporting actions downstream in the pipeline.
- Ensure the CODA file is accessible and of valid format to prevent parsing issues.
