​
Overview

The Analyze Table Block uses AI capabilities to perform complex analysis and transformations on tabular data. By providing a natural language prompt, you can instruct the AI to aggregate data, calculate summary statistics, or perform other sophisticated operations on your input table.

​
Inputs

​
Table
table
required

The input table to be analyzed. Should be an array of objects, where each object represents a row in the table.

​
Prompt
string
required

A natural language prompt describing the analysis or transformation to be performed on the table. This input is only available if “Use Prompt Input” is enabled in settings. The prompt guides the AI in generating the appropriate code for table analysis.

​
Outputs

​
Output
table

The resulting table after analysis or transformation. The structure of this table will depend on the operations specified in the prompt.

​
Duration
number

The time in milliseconds that the block took to execute.

​
Editor Settings

​
AI Model
string
default:"default"

The specific model to use for generating the analysis code. Available models are dynamically populated based on the LLM provider configuration.

​
Use Prompt Input
boolean
default:false

When enabled, allows the prompt to be provided via an input port instead of being set in the settings.

​
Prompt
string

The analysis prompt to use when “Use Prompt Input” is disabled. Describe the analysis you would like to perform on the table. The AI will generate the code for you.

​
Requirements

  • An LLM provider must be configured in the workflow context
  • A code interpreter endpoint must be set in the settings (Azure Code Interpreter)

​
Error Handling

The block will retry failed attempts up to 3 times with exponential backoff when encountering errors:

  • Retries occur between 500ms and 5000ms apart
  • Maximum of 3 retries before failing
  • Error details are provided in the trace logs

Common errors include:

  • Missing or invalid input table
  • Failed code generation from AI
  • Runtime errors in generated analysis code
  • Missing configuration for LLM provider or code interpreter

Always validate the output of the Analyze Table block, especially when working with critical data or making important decisions based on the results.

​
Example Usage

  1. Add an Analyze Table block to your flow
  2. Connect your input table to the Table input
  3. Either:
    • Enable “Use Prompt Input” and connect a prompt via the input port
    • Disable “Use Prompt Input” and enter your analysis prompt in settings
  4. Select your desired AI model
  5. Run the flow to get the analyzed table output

​
FAQ

​
See Also