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?

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

Contenuto pertinente