By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

DataBrew Filter

0

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?

Topics
Analytics
Tags
AWS Glue DataBrew
Language
English
AWS-User-7886902
asked 3 years ago384 views
1 Answer
0

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

profile pictureAWS
CHELSEA IP
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content