BIND_COLUMNS()

All functions > CORE > BIND_COLUMNS()

Binds columns from a table to the given features.

Signatures

Returns: A table with the selected columns bound to features

BIND_COLUMNS(columns: ARRAY<VARCHAR>, source_type: VARCHAR, source_content: VARCHAR) → TABLE<T>

Notes

• Binds specific columns from a source to features
• Supports multiple source types: TABLE(name), SQL(query), CSV(data), TSV(data), JSON(data)
• Column names are mapped to feature names in order
• Provides a simpler alternative to BIND_SQL for basic selections
• The number of columns must match the number of features
• Part of the FeatureMesh binding system

Examples

Bind INPUTs from physical table columns (with setup in same .slt file)

WITH
    INPUT1 := INPUT(BIGINT),
    INPUT2 := INPUT(BIGINT),
    ADD_INPUTS := INPUT1 + INPUT2,
SELECT
    INPUT1,
    INPUT2,
    ADD_INPUTS,
FOR
    (INPUT1, INPUT2) := BIND_COLUMNS(val1, val2 FROM TABLE(bnd.table_example)),