143 docs tagged with "mapping"

Streaming average across iterations.

Sample-and-hold memory cell that re-emits the last written value on every trigger.

Streaming count across iterations.

Streaming maximum across iterations.

Streaming minimum across iterations.

Streaming sum across iterations.

Returns array item at the specified index

Shift a Date or DateTime forward by a configurable amount and unit.

Render a Date, Time or DateTime as a string using a strftime-style format.

Convert a text to a date object

Convert a numeric Unix timestamp into a UTC DateTime.

Extract a single component (year, month, day, hour, …) from a date or datetime as a number.

Shift a Date or DateTime backward by a configurable amount and unit.

Convert a text to a datetime object

Calculate the duration between two dates

Returns current date and time

Convert a text to a time object

Assign multiple values to an Excel row

Get multiple values from an Excel row

Get a sheet from an Excel file

Extract cell from an Excel row

Put value into a cell on an Excel row

Get the cell value of an Excel sheet

Converts a number to a geolocation point

Foundational exit node automatically created inside every iterator scope.

Foundational entry node automatically created inside every iterator scope.

Return true only if every element of a list passes the per-element sub-graph predicate.

Keep only the elements of a list whose per-element sub-graph evaluates to true.

Return the first element of a list whose per-element sub-graph evaluates to true.

Flatten a nested JSON object/array into a single-level object whose keys are dotted paths.

Bucket elements of a list into a JSON object keyed by a per-element sub-graph result.

Transform each element of a list by running a sub-graph per element.

Fold a list into a single accumulated value by running a sub-graph per element.

Return true if at least one element of a list passes the per-element sub-graph predicate.

Sort a list by a per-element key extracted by a sub-graph.

Combine N input lists into one list of N-tuples.

Add a value to a JSON object

Data modeling, enforce complex object value.

Remove a single top-level key from a JSON object.

Get multiple values from a JSON object

Find the first object in a JSON array whose key field matches a filter value.

Parse a JSON string into a JSON value.

Add a key and value to a JSON object

Return the list of top-level keys of a JSON object.

Merge multiple JSON objects into one

Remove several top-level keys from a JSON object in one call.

Validate a JSON object against a schema

Extract a value from a JSON object using a path

Return the list of top-level values of a JSON object.

Split a list into a list of fixed-size sub-lists.

Concatenate several input lists into one.

Test whether a list contains a particular value.

Return the first element of a list.

Flatten a nested list — turn `[[1,2],[3,[4,5]]]` into `[1,2,3,4,5]`.

Return the 0-based position of the first occurrence of a value in a list, or -1 if absent.

Return the last element of a list.

Returns a random item from an list

Reverse the order of elements in a list.

Return a contiguous sub-list between start (inclusive) and end (exclusive).

Drop duplicate elements from a list, preserving the first occurrence's position.

Logical AND condition

Compare two Date or DateTime values with a chronological operator and emit a boolean.

TODO

Boolean NOT — emit the negation of an incoming boolean.

Filter number by a condition

First-non-null selector — emit the first wired value matching the configured type.

Logical OR condition

Filter text by a condition

Filter text by multiple conditions

Test whether a value matches a configured PValue type.

Return the absolute value of a number.

Average of numbers

Convert text into a BM25 sparse vector for hybrid vector search.

Restrict a number to a [min, max] range.

Count of numbers

Division of numbers

Compute the logarithm of a number, optionally with a custom base.

Maximum value of numbers

Mininum value of numbers

Remainder of the division of two numbers

Raise a number to the power of another number

Multiplication of numbers

Round a number

Return the square root of a number.

Total addition of numbers

Package an entire mini-graph behind a single reusable node.

Emit a fixed value baked into the configuration on every invocation.

Externally-fed constant — value supplied by the parser caller at execution time.

Convert a text to a number

Map a number to a text

Generate a random number

Extract several columns from a Parquet row in a single pass.

Read a CSV file line by line

Read an Excel file line by line

Read an Excel file workbook

Read a Google Sheet line by line

Read a JSON file elements by elements

Read a JSON file line by line

Read a PDF file page by page

Read an XML file elements by elements

Decode a standard base64 string into its UTF-8 source.

Encode a UTF-8 string to its standard base64 representation.

Concatenate two text values

Test substring containment.

Validate and decompose an email address per RFC 5322.

Test whether a string ends with a given suffix.

Join text values with a separator

Get the length of a text

Convert a text to lowercase

Look up a number from a string via a static mapping table.

Pad a string to a minimum character count by repeating a single fill character.

Validate and format a phone number using libphonenumber.

Generate a random text

Generate a random unique identifier

Capture element from a text using regexp

Replace a text match with another text

Reverse a string by character (Unicode-safe).

Decode a 22-char base64 ShortGuid back into the canonical 36-char UUID.

Slugify a string into a URL-safe form.

Split a text into a list of text values

Test whether a string begins with a given prefix.

Slice a substring out of a string by character indices.

Template text using placeholders

Re-case a string into camelCase, PascalCase, snake_case, kebab-case, and more.

Strip whitespace from the start, end, or both sides of a string.

Cap the output to a maximum number of characters with an optional ellipsis.

Convert a text to uppercase

Encode a canonical UUID into the 22-char base64 ShortGuid form.

List of all available types

Write an CSV file line by line

Write an Excel file line by line

Write a Google sheet line by line

Write elements to a JSON file

Write elements to a JSONL file

Write elements to an XML file

Add a value to a XML node

Get an attribute from a XML path

Get multiple values from an XML node

Learn about XML path

Convert an Excel sheet to a JSONL file

Execute given mapping

Keep a range of lines from a JSONL file

Convert a JSONL file to an Excel file