DataBrew: Can you define "Invalid value?"

0

Screenshot of DataBrew In the above screenshot, DataBrew has decided that every value in the "state" column was invalid. That's a specific problem, but I'd like the more general answer here; how can I define the rule for a "valid" value? I can do a similar task in the Data Quality rulesets, but I'm not looking to describe how good my data is; I'm trying to replace those invalid values with null.

質問済み 1年前286ビュー
1回答
0

I understand that you will like to know the definition of valid and invalid in the context of Databrew.

The validity of a column in Databrew is based on the column type. For instance , if we have a column called HIRE_DATE with column type date:

  • Valid in this context refers to the percentage of values with a valid date value
  • Invalid refers to the percentage of values with an invalid date value

To replace the invalid values with select 'Invalid' and transformation and replace with desired options presented

AWS
Sahil_S
回答済み 1年前
  • This does not explain why DataBrew decided my entire column should be null, nor does it really answer the question in any way.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ