Conditionals and comparison in DataBrew

0

Can Databrew set a column afternoon to be 1 if hour>12 and hour <16 , otherwise 0 ?

This requires

  1. Numerical comparison "less than" (not string comparison)
  2. Boolean and

This actually can be done with Databrew with some arithmetic transformations and the sign function, but that gets complicated.

Does Databrew support afternoon = (hour>12 and hour <16) ?

질문됨 4년 전691회 조회
3개 답변
0

Hi JoshuaFox,

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.

Best,
Romi

답변함 4년 전
profile picture
전문가
검토됨 6달 전
0

Romi,

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.

답변함 3년 전
0

Hi,

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?

답변함 3년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠