Prepare Recipe Formula

Hi,

Since you need to:

• define some "complex" rules to extract the values
• generate 2 columns

I think it's the easiest and fastest way to do that.

If I understood correctly your use case but you won't be able to translate that into simpler processors. Maybe you can share the corresponding formula used in the spreadsheet that you used for the screenshot?

To illustrate the "python function" that could be used to solve your problem here is an example code snippet:

def process(row):
    pairs = [['Col1', 'Val1'], ['Col2', 'Val2'], ['Col3', 'Val3']]
    max_val = None
    max_col = None
    max_val_undef = None  # Used when all the column names are undefined/unknown
    for column_column_name, value_column_name in pairs:
        current_column = get_column_name(column_column_name, row)
        current_value = float(row.get(value_column_name, '0'))
        if current_column is None:
            max_val_undef = max(current_value, max_val_undef)
        else:
            if max_val is None or current_value > max_val:
                max_val = current_value
                max_col = current_column

    if max_col is None:
        computed_column = ''
        computed_value = max_val_undef
    else:
        computed_column = max_col
        computed_value = max_val
    row['Col4'] = computed_column
    row['Val4'] = computed_value
    return row


def get_column_name(column_column_name, row):
    result = row.get(column_column_name, None)
    if result.lower() in ['undefined', 'unknown']:
        return None
    return result

I hope this helps.