...
| State | Qty |
|---|---|
| CA | 10 |
| OR | -10 |
| WA | 2.5 |
| ZZ | 15 |
| ID | |
| 4 |
Transformation:
Invalid State values: You can test for invalid values for State using the following:
| D trans | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
The above transform flags rows 4 and 6 as mismatched.
| Info |
|---|
NOTE: A missing value is not valid for a type, including String type. |
Invalid Integer values: You can test for valid matches for Qty using the following:
| D trans | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
The first transform flags rows 4 and 6 as mismatched.
| Info |
|---|
NOTE: A missing value is not valid for a type, including String type. |
The second transform flags above transform flags as valid all rows where the the Qty column column is a valid integer that is greater than zero.
Missing values: The following transform tests for the presence of missing values in either column:
...
After re-organizing the columns using the the move transform transform, the dataset should now look like the following:
...
