Validate normalization rules

Validate normalization rules

The table below provides details on the normalization rules for different data types.

Data type

String

Number

Boolean

Null

Data type

String

Number

Boolean

Null

String 

--

Number input type is always normalized to the string type, for example:

42 → "42"

The boolean values can be normalized to the string output type as:

true →  "true"

false → "false"

Null input type coerces to an empty string as shown:

null → ""

Number

String input type can be normalized to a number if the string is a valid number, for example:

"42" → 42

Normalization to an integer is possible if the string is a valid number without the fraction part. 

 

 

 

-- 

The boolean values can be normalized to a number type output types as follows:

true →  1

false → 0

Null input type normalizes to 0 as shown:

null → 0 

Boolean

Only the following strings can be normalized to the Boolean type:

"true" → true

"false" → false

Only the following numbers can be normalized to the  boolean data type:

1 → true

0 → false

 

 

 

--

 

Null value is normalized to a boolean false value as shown:

null → false

Null

Only empty strings can be normalized to null

Only empty strings can be normalized to null

Boolean value false normalized to null

true can't be normalized

 

 

--