For Windows and Mac

This release adds improvements and bug fixes to v1.34.0 on Windows and Mac. The download link is at the bottom of the page.

We recommend that you back-up important transform files before installing any new release. Please let us know of any problems or issues you encounter with the release.

You can uninstall old releases after you have successfully installed this version.

1. You can use the new **Num Base** transform for converting integers between different bases. For example, decimal to hexadecimal or binary to decimal.

Set **Base from** to the base of the current values. If you set it to **Guess**, it will guess the base for each value using C conventions:

- Numbers starting with 0x (e.g. 0x123) are assumed hexadecimal (base 16).
- Numbers starting with 0 (e.g. 0123) are assumed octal (base 8).
- All other values (e.g. 123) are decimal (base 10).

Set **Base to** to the base wanted.

For example to convert decimal to hexadecimal:

Or to convert from guessed base to decimal:

The input values should not contain commas or dots.

Negative values will be converted to unsigned values, unless you are converting to base 10.

See the **Num Base** transform documentation for more details.

2. You can use the new **Outliers** transform for dealing with outliers in numerical data.

For example to set outliers to empty based on quartiles and add a column with the outlier score:

- Set
**Score by**depending on whether you wish to score outliers using**Inter Quartile Range**or**Standard Deviation**. - Any values scoring greater than +
**Threshold**or less than -**Threshold**will be considered outliers. - Set
**Action**according to what you want to do with outlier values. - Set
**Non-numeric**according to what you want to do with non-numeric values. - Check
**add score column**to add a new column with the outlier scoring.

See the **Outliers** transform documentation for more details.

3. The following 2 operations have been added to the **Calculate** transform:

- DateTimeToMSecs: Converts an ISO datetime (e.g.
*2022-09-15:06:10.000*) to the number of milliseconds since 1970-01-01:00:00:00.000 (e.g.*1663272370000*). - MSecsToDateTime: Converts an integer number of milliseconds since 1970-01-01:00:00:00.000 (e.g.
*1663272370000*) to an ISO datetime (e.g.*2022-09-15:06:10.000*).

Note that you need to divide millisecond by 1000 to get the Unix timestamp, which is *seconds* since 197000:00:00:00. Thanks to Louis K. for suggesting this.

See the **Calculate** transform documentation for more details.

4. The **Sort** transform now has the option to add a rank column by checking **Add rank**.

The following Rank types are available:

**Minimum**: Uses the minimum rank of each group.**Average**: Uses the average rank of each group.**Maximum**: Uses the maximum rank of each group.**Dense**: Each successive rank is only incremented by 1. There are no gaps.**Cumulative**: Shows the proportion of rows (0 to 1) with the same or lower numbered rank

For example:

Is ranked by **Rank type** as:

Sorted score | Minimum | Average | Maximum | Dense | Cumulative |
---|---|---|---|---|---|

131 | 1 | 1 | 1 | 1 | 0.167 |

123 | 2 | 3 | 4 | 2 | 0.667 |

123 | 2 | 3 | 4 | 2 | 0.667 |

123 | 2 | 3 | 4 | 2 | 0.667 |

120 | 5 | 5.5 | 6 | 3 | 1 |

120 | 5 | 5.5 | 6 | 3 | 1 |

Set **Rank by** to a column to rank separately for each distinct value in this column. Leave it as *<None selected>* if you only want a single ranking for all rows.

If you want to rank rows without losing the original order, use **Row Num** to add a row number before the **Sort**, and then use another **Sort** on the **Row Num** column to return to the original order.

See the **Sort** transform documentation for more details.

5. Data copied from the Right pane now includes the header, if whole columns are copied.

6. You can now set the amount of detail shown in tool tips in the Center pane as detailed, brief or off using the **View>Show Tool Tips** menu.

v1.35.0 for Windows 11/10/8/7 (44 MB)

v1.35.0 for Mac 12.x to 10.13 (56 MB)

Questions or problems?