Problemunvalidated
So far I can get both groups valid and invalid if tomato appears in the set. — I have a set of data that I group by "product_group_id", "group_name" and "class". Tension: I want to check the "name" list and if "tomato" name exists in the set I will add "invalid" value or "valid" to the new "label" column. Outcome: You need to use an aggregated function e.g. `max` to check the tomato and not group by on the `label`.
32153f09-84a1-4323-bebf-339a4129a836
So far I can get both groups valid and invalid if tomato appears in the set. — I have a set of data that I group by "product_group_id", "group_name" and "class". Tension: I want to check the "name" list and if "tomato" name exists in the set I will add "invalid" value or "valid" to the new "label" column. Outcome: You need to use an aggregated function e.g. max to check the tomato and not group by on the label.