DataBrew Filter

Question

Is there a way to filter a column in DataBrew using the contains operator in a case where you would like to filter by more than one word? I would like to filter an address column that contains the words Miami Beach. I can do a contains filter by the first word or the second but not both, it seems?

CHELSEA IP · Answer

Hi there,

I downloaded a sample data in Glue Data Brew to understand things from your perspective.

From my observation:
You can apply filter 'contains' operator 2 consecutive times, let's say you add a filter for 'Turned' then you add a second filter for 'Armchair'. You would need to repeat the same steps to achieve this.

Let me know if you need further assistance

DataBrew Filter

Füge deine Antwort hinzu

Relevanter Inhalt