Data Nodes

Data Nodes

The Data Nodes category provides tools for transforming, converting, and manipulating data within Databraid. These nodes are essential for preparing, enriching, and processing structured and semi-structured data.

Available Nodes

Below is a list of available nodes in the Data category:

1. CSVToJSONNode

   • Converts data from CSV format to JSON.
   • Useful for working with tabular data in JSON-based environments.

2. ExcelToJSONNode

   • Transforms Excel spreadsheets into JSON format.
   • Supports selecting specific sheets and headers.

3. JSONToCSVNode

   • Converts JSON data into a CSV format.
   • Ideal for exporting structured data into tabular form.

4. JSONExtractorNode

   • Extracts specific fields or substructures from complex JSON data.
   • Simplifies data extraction from nested structures.

5. JoinNode

   • Merges multiple input texts into a single concatenated output.
   • Offers options for timeouts and strict modes to manage merging behavior.

6. JsonataNode

   • Applies JSONata queries and transformations to JSON data.
   • Provides flexible and powerful JSON processing capabilities.

7. JSONPathNode

   • Accesses and manipulates JSON structures using JSONPath queries.
   • Ideal for retrieving or modifying specific elements in JSON data.

Usage Examples

Each node in this category is designed to seamlessly integrate with Databraid workflows. For example:

• Use CSVToJSONNode to preprocess tabular data before further transformations.
• Combine JsonataNode and JSONExtractorNode to query and extract precise data for downstream nodes.

For detailed information about each node, click on its name to access the corresponding documentation page.

---

Next Steps

Explore the detailed documentation of each Data Node to understand its inputs, outputs, and properties. Incorporate these nodes into your workflows to unlock the full potential of your data.