...
In the data quality bar, missing values are identified in blackgray:
| D caption | ||
|---|---|---|
| ||
Missing values in blackgray |
| Tip |
|---|
Tip: From the Transformer page, click the missing values in a column to see their count, highlight them in the rows of the data grid, and trigger a set of suggestions for your review. |
...
| Info |
|---|
NOTE: Generally speaking, inserting constants in place of missing values is not a recommended practice, especially if downstream consuming applications and individuals may not be known. In particular, you should not replace missing numeric values with a fixed numeric value, which will skew analysis. Use this method only if your entire data chain is aware of the constants. |
Steps:
Click the black gray missing values segment of the data quality bar for the column to fix.
Tip Tip: Select a missing value in the data grid. Then, select the
replacesuggestion and then modify it to include the replacement value.- In the suggestion cards, click the
setsuggestion. - By default, this transform sets the missing value to be a null value. Click Edit.
You might seem something like the following:
D trans Type step p01Name Columns p01Value country p02Name Formula p02Value IF(ISMISSING([country]),NULL(),country) SearchTerm Edit column with formula
The missing data is identified using the
row:ISMISSINGreference. To apply a constant, replace theNULL()reference with a constant value, as in the following:D trans Type step p01Name Columns p01Value country p02Name Formula p02Value IF(ISMISSING([country]),'USA',country) SearchTerm Edit column with formula Note that the single quotes around the value are required, since it identifies the value as a constant.
Click Add.
...
