Thank you for reaching out. Logical operations are on the roadmap (and, or, not, etc) as is richer data type support. For now there are a couple ways you could achieve your needs depending on the shape of the data in your column.
If it is presented in a String column with a timestamp format I would recommend using the Flag transformation. You could then use a custom value to flag a customer regex (something along the lines of 1\[2-6]:\[0-5]\[0-9]:\[0-5]\[0-9]), and set it to flag as 1 or 0.
If it is presented as a Number column you can use the Column filter icon on the column header, this will open up a modal with different conditions including less than and greater than. By clicking the primary Filter values button, the conditions will be added visually but not applied as a recipe step. Then you can choose to apply your next step only on the filtered values.
Thank you for that answer.
Are much simpler conditionals possible? Column B is "1" if an only if Column A is "999" (String or Number)? I have asked it here https://forums.aws.amazon.com/thread.jspa?threadID=339388&tstart=0
and if you can answer that I would appreciate it.
Yesterday I was able to use CASE function in aws databrew, but this function disappeared today for some reason, could you please advise what happened and when can I use CASE function again?
DataBrew Filterasked 5 months ago
Databrew Data Quality Queries
Tracking record-level failure from Databrew validationasked 4 months ago
[On-Premise] Face comparison on premise?asked 7 months ago
Text data cleaning in databrewasked 2 months ago
Can you export Glue DataBrew recipies as code?Accepted Answerasked 2 years ago
Should ECS/EC2 ASGProvider Capacity Provider be able to scale-up from zero, 0->1Accepted Answerasked 8 months ago
Trigger databrew job multiple times
Is there an option in AWS Glue DataBrew to keep only the required columns and delete the rest?Accepted Answerasked 2 years ago
Conditionals and comparison in DataBrewasked 2 years ago