pipeline.add(name="...").<node>(...). Each entry lists the node’s configuration parameters. See the Pipeline reference for add, run, and lifecycle methods.
ai_filter_list
Filter items in a list given a specific AI condition. Example, Filter (Red, White, Boat) by whether it is a color: (Red, White)
Choose whether to filter a single list or filter by another list
One of:
another, singleThe model provider
The specific model for filtering
Write in natural language the condition to filter each item in the list
The items to filter the list by
The list to filter
If true, output a blank value for values that do not meet the filter condition. If false, nothing will be outputted
combine_list
Combine multiple lists into one list. Final list is ordered in the order of the input lists.
The type of the list
List to be combined
combine_text
Combine text inputs into a singular output.
create_list
Create a list from input texts. Final list is ordered in the order of the inputs.
The type of the list
Value to be added to the list
csv_query
Utilizes an LLM agent to query CSV(s). Delimeter for the CSV must be commas.
csv_reader
Read the contents from a CSV file and output a list of the data for each column.
The type of file to read.
One of:
CSV, EXCELThe file to read.
The Excel sheet to read from.
Define the name(s) of the columns that you want to read
Define the name(s) of the columns that you want to read
csv_to_excel
Convert a CSV file into XLSX.
One of:
center, centerContinuous, distributed, fill, general, justify, left, rightOne of:
bottom, center, distributed, justify, topcsv_writer
Create a CSV from data.
Whether to create a new CSV or update an existing one.
One of:
new, oldWhether to load the CSV from a file or a string.
One of:
file, textThe columns to write to the CSV.
The file to update.
The CSV string to write.
dataframe_aggregate
Aggregate data from a dataframe.
The type of dataframe to be used
One of:
tableSelect a numeric column (integer or decimal) to perform aggregation
The aggregation to perform
One of:
AVG, COUNT, MAX, MIN, SUMThe dataframe to aggregate
The columns to group by
dataframe_get_schema
Get the schema of a dataframe including columns, types, and constraints.
The type of dataframe to be used
One of:
tableThe dataframe to get schema from
dataframe_nl_query
Execute natural language queries on dataframes.
The type of dataframe to be used
One of:
tableThe dataframe to query using natural language
Ask a question about your data in natural language. Example: What are the top 10 rows?
dataframe_operations
Dataframe Operations
dataframe_raw_query
Execute custom queries on dataframes.
The type of dataframe to be used
One of:
tableSQL query to execute on the dataframe. Use {df} as the table name placeholder. Example: SELECT * FROM {df} limit 10;
The dataframe to query
Whether to preload dataframe instead of lazy load
dataframe_read_columns
Read columns from a dataframe.
The expected type of the column values
The type of dataframe to be used
One of:
tableThe name of the column to read
duplicate_list
Create a new list by duplicating a single item with the size of the new list either matching the size of another list, or a specified size.
Check this box if you want to manually specify the list size. In this case ‘Match List Size’ will not be used.
The type of the list
Item to duplicate
The size of the list you want to match
The size of the new list
excel_cell_reader
Read data from an Excel cell.
excel_cell_writer
Write data to an Excel cell.
Whether to set the vertical alignment of the cell.
Whether to set the horizontal alignment of the cell.
Whether to set the fill color of the cell.
The cell to read from.
The value to write to the cell.
The fill color of the cell.
The horizontal alignment of the cell.
One of:
center, centerContinuous, distributed, fill, general, justify, left, rightThe file to read from.
The sheet to read from.
The vertical alignment of the cell.
One of:
bottom, center, distributed, justify, topexcel_file_reader
Read data from an Excel file.
Whether to read a single sheet from the Excel file.
Whether to read the formatting of the cell.
Whether to read the formula of the cell.
The file to read from.
The sheet to read from.
excel_operations
Process and manipulate Excel files
excel_sheets_reader
Get list of all sheet names from an Excel file.
excel_writer
Write data to an Excel sheet.
Whether to set the vertical alignment of the cells.
Whether to set the horizontal alignment of the cells.
Whether to set the fill color of the cells.
The cell to start writing from.
The values to write to the cells.
The fill color of the cells.
The horizontal alignment of the cells.
One of:
center, centerContinuous, distributed, fill, general, justify, left, rightThe file to write to.
The sheet to write to.
The vertical alignment of the cells.
One of:
bottom, center, distributed, justify, topextract_to_table
Extract data to a CSV using AI
One of:
gpt-4o, gpt-4o-2024-08-06, gpt-4o-miniOne of:
openaifilter_list
Filter items in a list given a specific condition. Example, Filter (Red, White, Blue) by (100, 95, 80)>90 is (Red, White)
Choose whether to filter a single list or filter by another list
One of:
another, singleThe type of the list
The type of condition to apply
The value to compare the list items against
The items to filter the list by
The list to filter
If true, output a blank value for values that do not meet the filter condition. If false, nothing will be outputted
find_and_replace
Find and replace words in a given text
flatten_list
Flatten list of lists into a single list. For example, [[a, b], [c, d]] becomes [a,b,c,d].
The type of the list
List of lists to be flattened
generate_chart
Use this to generate a chart from. Convert a tabular file, dataframe or table to a chart or graph visualization. Supports bar, line, pie, scatter, and donut charts/graphs.
The type of chart to generate (bar, line, pie, scatter, donut)
One of:
bar, donut, line, pie, scatter, time_seriesHow to aggregate values when there are multiple data points per category
One of:
average, count, max, min, sumA brief description or subtitle explaining what the chart shows
The dataframe to visualize as a chart. In case of csv, the input should be a properly formatted valid csv string with appropriate headers. When chaining from a tool that returned a CSV file (e.g. fetch_ratios.table), set dataframe_type=“file” and pass $action.<id>.table — never paste the upstream formatted_text/XML here.
Actual column names from the dataframe. It should be a string representing the comma separated list of column names.
The type of dataframe to be used. Only available options are table, csv, md, json, file.
One of:
csv, file, json, md, tableWhere to display the chart legend
One of:
bottom, hidden, left, right, topThe order to sort the data
One of:
ascending, descendingThe title to display on the chart
The column name to use for the X-axis (categories). Must EXACTLY match (case-sensitive) one of the column names from the CSV header.
The label to display on the X-axis. Defaults to the field name if not provided.
Column name(s) for Y-axis values. Must EXACTLY match (case-sensitive) column name(s) from the CSV header. For multi-series charts (multiple lines/bars), use comma-separated names like ‘revenue,profit,cost’.
The label to display on the Y-axis
Currency symbol (only used with currency format)
One of: “,
eur, gbp, jpy, usdInitial time period tab selection
One of:
1m, 1y, 5y, 6m, max, ytdHow to format values
One of:
currency, number, percent, ratioComma-separated icon URLs for each series (company logos, game art, product images, etc.), in same order as y_axis_fields. Leave empty for no icons.
Comma-separated display names for each Y-axis field, in same order as y_axis_fields (e.g. ‘MSFT,NVDA’ for tickers, ‘Halo,Fortnite’ for games, ‘US,EU,APAC’ for regions).
Set to ‘true’ to show Original/% Change toggle
Scale suffix for values
One of: “,
b, k, m, tget_list_item
Get a value from a list given an index. The first item in the list is index 0.
The type of the list
The index of the item to retrieve
The list to retrieve the item from
join_list_item
Join a list of items into a single piece of text. For example, with / as the separator, [‘a’, ‘b’, ‘c’] becomes ‘a/b/c’
Separate each line in the final output with a new line
The type of the list
Use a specified character to join list items into a single string
List of items to be joined
json_operations
Read, create, and update JSON data
list_deduplicator
Remove duplicate items from a list. Outputs a list of unique items.
The type of the list
One of:
bool, float, int32, string, timestampThe list to deduplicate
list_operations
Process and manipulate lists
list_trimmer
Trim a list to just the sections you want. Enter enter the number of items or specify the section of the list that you want to keep.
Check this to specify a section of the list to keep. Leave unchecked to keep a specified number of items from the start.
The type of the list
The ending index of the section to keep (exclusive).
The list to trim
The starting index of the section to keep (inclusive). The first item of the list is index 0.
Check this to specify a section of the list to keep. Leave unchecked to keep a specified number of items.
read_json_values
Read values from a JSON object based on a provided key(s).
sort_csv
Sort a CSV based on a column
Whether the file is a variable.
Whether the CSV has headers.
The index of the column to sort by.
The CSV file to sort.
Whether to reverse the sort.
The column to sort by.
split_text
Takes input text and separate it into a List of texts based on the delimiter.
The delimiter to split the text on
One of:
character(s), newline, spaceThe text to split
The character(s) to split the text on
table
Table
table_add_columns
Add one or more columns to a table.
table_add_row
Add New Row to Table.
table_aggregate
Aggregate data from a table.
One of:
AVG, COUNT, MAX, MIN, SUMtable_delete_columns
Delete one or more columns from a table.
table_delete_values
Delete rows matching a filter.
table_read_columns
Select column in table to read as list.
The expected type of the column values
The name of the column to read
The table to read from
table_rename_column
Rename a column in a table.
table_update_values
Update the values in rows matching a filter.
text_formatter
Format text based off a specified formatter
The formatter to apply to the text
One of:
To Lowercase, To Propercase, To Uppercase, Trim Spaces, TruncateThe text to format
The maximum number of tokens to truncate the text to
text_manipulation
Process and manipulate text
write_json_value
Update a specific value in a JSON.
Whether to update the JSON value or create a new JSON
One of:
new, oldThe JSON to update