CSV File Node

​

Node Details

• Name: csvFile
• Type: Document
• Version: 2.0
• Category: Document Loaders

​

Input Parameters

1. Csv File (required)
   • Type: file
   • File Type: .csv
   • Description: The CSV file to be processed
2. Text Splitter (optional)
   • Type: TextSplitter
   • Description: A text splitter to break down large documents
3. Single Column Extraction (optional)
   • Type: string
   • Description: Name of a specific column to extract from the CSV
   • Placeholder: Enter column name
4. Additional Metadata (optional)
   • Type: json
   • Description: Additional metadata to be added to the extracted documents
5. Omit Metadata Keys (optional)
   • Type: string
   • Description: List of metadata keys to omit from the output, separated by commas
   • Special value: Use ”*” to omit all metadata keys except those specified in Additional Metadata

​

Outputs

1. Document
   • Description: Array of document objects containing metadata and pageContent
   • Base Classes: Document, json
2. Text
   • Description: Concatenated string from pageContent of documents
   • Base Classes: string, json

​

Functionality

1. File Loading:
   • Supports loading CSV files from base64-encoded strings or file storage
   • Can process single files or multiple files (when provided as a JSON array)
2. Data Extraction:
   • Extracts data from CSV files using the CSVLoader from langchain
   • Optionally focuses on a single column if specified
3. Text Splitting:
   • If a text splitter is provided, it splits the loaded documents
4. Metadata Handling:
   • Adds custom metadata to documents if provided
   • Can selectively omit default metadata fields
5. Output Formatting:
   • Can output as an array of document objects or as concatenated text

​

Use Cases

• Loading and processing CSV data for natural language processing tasks
• Extracting specific columns from CSV files for analysis
• Preparing CSV data for use in language models or other AI applications
• Combining CSV data with custom metadata for enriched document processing

​

Notes

• The node handles escape characters in the output text
• It’s designed to work within a larger system, likely a workflow or pipeline for document processing