How can I remove all rows where first-name doesn't start with A?

Comments

  • AMuresan
    AMuresan

    This is a slightly interesting one.

    The first thing to do is identify the rows where first name starts with 'A', you can use the formula tool for this

    image.png

    Then we'll filter out any rows where the new "temp_keep" column is True, we can use filter tool:

    image.png

    Now don't forget you have this new unsightly column lying around, so drop it with the drop tool:

    image.png


Categories