Summary:

Selects a single non-null value from rows in each group that meet a specific condition.

See: ANYIF Function.

wrangle;language;reference;function;aggregate;row;any;anyif;wrangle_function_anyif;pivot;