Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Navigation
- Tecnomatix
- Forums
- Blogs
- Knowledge Bases
- Groups

- Siemens PLM Community
- Tecnomatix
- Plant Simulation
- Sorting real values in tablefile

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-30-2016 05:46 AM

Hi, I have a problem sorting real values in a tablefile.

The problem is not linked to the sort method directly (<Path>.sort(SortOrder:<any>); this works OK for me).

It is linked to the number of digits considered in sorting. It seems that only 6 digits are considered in sorting. For example, 0.1234567 and 0.1234568 are not considered to be different in sorting a column. In my case these numbers represent processing times, to be sorted according to a shortest processing time rule. Precision is important here.

Anybody having similar type of problems?

Solved! Go to Solution.

4 REPLIES

Re: Sorting real values in tablefile

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-30-2016 06:23 AM

I've checked with v11 and v13. Both versions sort real numbers with 8 or more digits correct.

Therfore pls send your spp-file containing the tab-object with the real-numbers to be sorted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-30-2016 07:31 AM

Hi D-J,

Up to version 13 only 6 digits after decimal point are considered for sorting.

For single column sort in version 13 the exact numbers are compared.

@simulator: Could you please redo your test with V11?

Just try to sort a real column with the following numbers in V11:

0.123456789

0.1234567

0.1234568

0.1234567

0.1234568

Regards,

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-31-2016 03:27 PM

I just tried a simple workaround: multiplying values in the table by 100

and next sorting.

For this specific case it solves issues.

Thanks for your efforts and information.

D-J.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

05-31-2016 03:27 PM

I just tried a simple workaround: multiplying values in the table by 100

and next sorting.

For this specific case it solves issues.

Thanks for your efforts and information.

D-J.

Follow Siemens PLM Software

© 2019 Siemens Product Lifecycle Management Software Inc