This example demonstrate the following comparison functions.
In this example, the dataset contains current measurements of the sides of rectangular areas next to the size of those areas as previously reported. Using these functions, you can perform some light analysis of the data.
Source:
| sideA | sideB | reportedArea |
|---|
| 4 | 14 | 56 |
| 6 | 6 | 35 |
| 8 | 4 | 32 |
| 15 | 15 | 200 |
| 4 | 7 | 28 |
| 12 | 6 | 70 |
| 9 | 9 | 81 |
Transformation:
In the first test, you are determining if the four-sided area is a square, based on a comparison of the measured values for sideA and sideB:
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | 'isSquare' |
|---|
| Type | step |
|---|
| WrangleText | derive type:single value:EQUAL(sideA, sideB) as:'isSquare' |
|---|
| p01Name | Formula type |
|---|
| p01Value | Single row formula |
|---|
| p02Name | Formula |
|---|
| p02Value | EQUAL(sideA, sideB) |
|---|
| p03Name | New column name |
|---|
| SearchTerm | New formula |
|---|
|
Next, you can use the reported sides to calculate the area of the shape and compare it to the area previously reported:
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | 'isValidData' |
|---|
| Type | step |
|---|
| WrangleText | derive type:single value:NOTEQUAL(sideA * sideB, reportedArea) as:'isValidData' |
|---|
| p01Name | Formula type |
|---|
| p01Value | Single row formula |
|---|
| p02Name | Formula |
|---|
| p02Value | NOTEQUAL(sideA * sideB, reportedArea) |
|---|
| p03Name | New column name |
|---|
| SearchTerm | New formula |
|---|
|
You can also compute if the reportedArea can be divided into even square units:
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | 'isReportedAreaEven' |
|---|
| Type | step |
|---|
| WrangleText | derive type:single value:ISEVEN(reportedArea) as:'isReportedAreaEven' |
|---|
| p01Name | Formula type |
|---|
| p01Value | Single row formula |
|---|
| p02Name | Formula |
|---|
| p02Value | ISEVEN(reportedArea) |
|---|
| p03Name | New column name |
|---|
| SearchTerm | New formula |
|---|
|
You can test if either measured side is an odd number of units:
| D trans |
|---|
| RawWrangle | true |
|---|
| p03Value | 'isSideOdd' |
|---|
| Type | step |
|---|
| WrangleText | derive type:single value:IF((ISODD(sideA) == true) OR (ISODD(sideB) == true),TRUE,FALSE) as:'isSideOdd' |
|---|
| p01Name | Formula type |
|---|
| p01Value | Single row formula |
|---|
| p02Name | Formula |
|---|
| p02Value | IF((ISODD(sideA) == true) OR (ISODD(sideB) == true),TRUE,FALSE) |
|---|
| p03Name | New column name |
|---|
| SearchTerm | New formula |
|---|
|
Results:
| sideA | sideB | reportedArea | isSquare | isValidData | isReportedAreaEven | isSideOdd |
|---|
| 4 | 14 | 56 | FALSE | FALSE | TRUE | FALSE |
| 6 | 6 | 35 | TRUE | TRUE | TRUE | FALSE |
| 8 | 4 | 32 | FALSE | FALSE | TRUE | FALSE |
| 15 | 15 | 200 | TRUE | TRUE | TRUE | TRUE |
| 4 | 7 | 28 | FALSE | FALSE | TRUE | TRUE |
| 12 | 6 | 70 | FALSE | TRUE | TRUE | FALSE |
| 9 | 9 | 81 | TRUE | FALSE | FALSE | FALSE |
