Knowledge and Data Processing Nodes
4. Knowledge and Data Processing Nodes
Knowledge and data processing nodes are used in SkyStudio workflows to process file and table data, search knowledge sources, transform data, perform calculations, and generate structured data.
These nodes allow operations such as converting files into tables, processing JSON data, querying table data, saving data to knowledge sources, and searching those sources to be incorporated into workflows.
After the nodes are added to the workspace, the required parameters can be configured according to the selected operation. Data from previous nodes can also be connected as parameters in the relevant fields by using the / character.
4.1. File to Table
The File to Table node is used to convert file content received by the workflow into a table format.
A file provided by the File Input node or a previous node can be passed to this node. The converted table data can then be used in subsequent nodes for querying, analysis, or data processing.
4.2. JSON to Table
The JSON to Table node is used to convert data in JSON format into a table structure.
API responses or JSON data generated by previous nodes can be converted into structured table data through this node.
The generated table can be used in subsequent data processing and querying steps.
4.3. List Tables
The List Tables node is used to list available tables.
It can be used when you need to view the tables accessible within the workflow or identify the table to be used in subsequent operations.
4.4. Table Data
The Table Data node is used to access data in a selected table.
After selecting the relevant table, the data within the table can be passed into the workflow and processed by subsequent nodes.
This node can be used when previously created or stored table data needs to be reused within a workflow.
4.5. Query
The Query node is used to perform queries on table data.
The query can be used to select or filter the required data. The resulting data can then be passed to subsequent workflow steps.
This node is particularly useful when only specific records need to be retrieved from large datasets.
4.6. Knowledge Save
The Knowledge Save node allows content obtained within the workflow to be saved to a knowledge source.
Content from previous nodes can be transferred to the specified knowledge source and made available for future searches.
This node can be used in scenarios where information obtained during a workflow needs to be stored for later use.
4.7. Knowledge Search
The Knowledge Search node is used to search within defined knowledge sources.
The search query can be defined as a fixed value or generated dynamically using data from previous nodes.
Content returned by the search can be passed to subsequent nodes. It can be particularly useful when combined with LLM nodes, allowing the model to generate responses based on content retrieved from relevant knowledge sources.
4.8. Text2data
The Text2data node is used to convert information within text into structured data.
It can be used in workflows where specific fields or values need to be extracted from unstructured text.
The resulting structured data can be used as parameters in subsequent nodes or passed to other data processing steps.
4.9. Transform
The Transform node is used to transform the structure or format of data within a workflow.
Data received from previous nodes can be adapted to match the data structure required by subsequent nodes.
This node is particularly useful when data formats need to be adapted between different nodes.
4.10. Formula
The Formula node is used to perform formula-based calculations on data within a workflow.
Numeric values or other suitable values received from previous nodes can be used within the formula.
The calculated value can then be passed to subsequent workflow steps.
4.11. Parameter
The Parameter node allows you to define parameters that will be used within the workflow.
Defined values can be used in subsequent workflow steps and passed as parameters to different nodes.
This node can be used when the same value needs to be used in multiple parts of a workflow or when specific values need to be defined centrally.
4.12. Save Data
The Save Data node allows data generated during a workflow to be stored for later use.
Stored data can be used in subsequent runs or other steps of the workflow.
For example, it can be used in a workflow that runs at specific intervals when the result of a previous run needs to be stored and compared with new results.
4.13. SkyData
The SkyData node is used to access SkyStudio's data service.
Data sources defined within the platform can be selected and queried through this node.
The source to be accessed is selected from the Data Source field. When required, the Query field can be used to filter the data.
4.14. Form Builder
The Form Builder node allows you to create forms for collecting structured data from users during a workflow.
It can be used when users need to complete specific fields instead of providing information as free-form text.
Different field types can be defined within the form, including text, long text, number, date, selection, and checkbox fields.
The information to be collected from the user is defined through Form Fields. When required, a Title and Description can also be configured for the form.