nodes/generated

Interface MergeV3NodeParameters

Source
interface MergeV3NodeParameters {
    advanced?: boolean;
    chooseBranchMode?: "waitForAll";
    combineBy?:
        | "combineByFields"
        | "combineByPosition"
        | "combineAll";
    fieldsToMatchString?: string;
    joinMode?: | "keepMatches"
    | "keepNonMatches"
    | "keepEverything"
    | "enrichInput1"
    | "enrichInput2";
    mergeByFields?: {
        values: { field1?: string; field2?: string }[];
    };
    mode?: | "append"
    | "combine"
    | "chooseBranch"
    | "combineBySql";
    numberInputs?: 3
    | 2
    | 4
    | 5
    | 10
    | 6
    | 7
    | 8
    | 9;
    options?:
        | {
            clashHandling?: {
                values: {
                    mergeMode?: "deepMerge"
                    | "shallowMerge";
                    overrideEmpty?: boolean;
                    resolveClash?: string;
                };
            };
            fuzzyCompare?: boolean;
        }
        | {
            clashHandling?: {
                values: {
                    mergeMode?: "deepMerge"
                    | "shallowMerge";
                    overrideEmpty?: boolean;
                    resolveClash?: string;
                };
            };
            disableDotNotation?: boolean;
            fuzzyCompare?: boolean;
            multipleMatches?: "all"
            | "first";
        }
        | { emptyQueryResult?: "empty"
        | "success" }
        | {
            clashHandling?: {
                values: {
                    mergeMode?: "deepMerge" | "shallowMerge";
                    overrideEmpty?: boolean;
                    resolveClash?: string;
                };
            };
            includeUnpaired?: boolean;
        };
    output?: "empty"
    | "specifiedInput";
    outputDataFrom?: "input1" | "input2" | "both";
    query?: string;
    useDataOfInput?: string;
}

Properties§

Source§

readonly advanced?: boolean

Whether name(s) of field to match are different in input 1 and input 2

Source§

readonly chooseBranchMode?: "waitForAll"

Default: "waitForAll"

Source§

readonly combineBy?: "combineByFields" | "combineByPosition" | "combineAll"

How input data should be merged Default: "combineByFields"

Source§

readonly fieldsToMatchString?: string

Specify the fields to use for matching input items

Source§

readonly joinMode?:
    | "keepMatches"
    | "keepNonMatches"
    | "keepEverything"
    | "enrichInput1"
    | "enrichInput2"

How to select the items to send to output Default: "keepMatches"

Source§

readonly mergeByFields?: { values: { field1?: string; field2?: string }[] }

Specify the fields to use for matching input items Default: {"values":[{"field1":"","field2":""}]} Type options: {"multipleValues":true}

Source§

readonly mode?: "append" | "combine" | "chooseBranch" | "combineBySql"

How input data should be merged Default: "append"

Source§

readonly numberInputs?: 3 | 2 | 4 | 5 | 10 | 6 | 7 | 8 | 9

The number of data inputs you want to merge. The node waits for all connected inputs to be executed. Default: 2

Source§

readonly options?:
    | {
        clashHandling?: {
            values: {
                mergeMode?: "deepMerge"
                | "shallowMerge";
                overrideEmpty?: boolean;
                resolveClash?: string;
            };
        };
        fuzzyCompare?: boolean;
    }
    | {
        clashHandling?: {
            values: {
                mergeMode?: "deepMerge"
                | "shallowMerge";
                overrideEmpty?: boolean;
                resolveClash?: string;
            };
        };
        disableDotNotation?: boolean;
        fuzzyCompare?: boolean;
        multipleMatches?: "all"
        | "first";
    }
    | { emptyQueryResult?: "empty"
    | "success" }
    | {
        clashHandling?: {
            values: {
                mergeMode?: "deepMerge" | "shallowMerge";
                overrideEmpty?: boolean;
                resolveClash?: string;
            };
        };
        includeUnpaired?: boolean;
    }

Default: {}

Source§

readonly output?: "empty" | "specifiedInput"

Default: "specifiedInput"

Source§

readonly outputDataFrom?: "input1" | "input2" | "both"

Default: "both"

Source§

readonly query?: string

Input data available as tables with corresponding number, e.g. input1, input2 Default: "SELECT * FROM input1 LEFT JOIN input2 ON input1.name = input2.id" Type options: {"rows":5,"editor":"sqlEditor"}

Source§

readonly useDataOfInput?: string

The number of the input to use data of Default: 1 Type options: {"minValue":1,"loadOptionsMethod":"getInputs","loadOptionsDependsOn":["numberInputs"]}