Icon

Find Target Sum Column Combinations

Options

Allow Closest Not Exceeding
Specify whether if no exact match, or match within tolerance is found, whether you will accept the combination of columns with the closest match that does not exceed the target value
Key Column
Choose the column that is the identifying unique key for each row
Target Value Column
Choose the column that specifies the target value to find for each row
Tolerance to Target Calculation
Specify the maximum tolerance (difference) between the sum of the columns and the target value that will be considered a match
Round Error Decimal Places
Specify the number of decimal places to round to to avoid rounding errors within python
Value Column Name prefix
Specify the prefix for the value column names. Value columns should all have the same prefix followed by an integer%%00010e.g. %%00010Value1, Value2

Input Ports

This node has no input ports

Output Ports

This node has no output ports

Nodes

Extensions

Links