Skip to main content
wjamieson1-Visitor
1-Visitor
Apr 8, 2015 8:17 PM UTC
Solved

Sorting a Column of 2D Family Table (Repeat Region Table)

I am trying to sort a column of a 2D repeat region table, how do I do this? The 2D repeat region table is derived from a family table. I do not want to change the way the original family table is sorted. I would also like to re-order the parameter name columns in the table. I am using Creo 2.0. Thanks for your help!

MartinHanakAnswer
24-Ruby III
Apr 9, 2015 9:16 PM UTC

William,

in attached Word document you can find information, how to create parametric sorted table of hex_jam_nut family table. Unfortunatelly the solution enables you to sort table according to CORNERS value or instance name, only.

You can also test "non-parametric solution":

  • open Family table editor and click File > Edit with Excel
  • open new empty Excel book, copy family table information into it and save it
  • insert this standalone Excel book into the drawing as linked object
  • every change in standalone Excel book will be transfered into the drawing, when you reopen it

Good luck

Martin Hanak

View in thread

16 replies

MartinHanak24-Ruby III
24-Ruby III
Apr 9, 2015 4:39 AM UTC

William,

use a procedure described in http://support.ptc.com/cs/cs_27/howto/dwt_no2d/dwt_no2d.htm (mentioned in https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS24968).

Martin Hanak


Translate
wjamieson1-VisitorAuthor
1-Visitor
Apr 9, 2015 12:28 PM UTC

Martin,

Thanks for the tutorial. I had found this before, but I cannot get it to work. After following the instructions and applying the filters, When I sort regions, Creo only will sort the names in the "Instance Name" column... but not the other columns. Is this tutorial only for Pro Engineer or older versions of PTC software? Thanks for your help.

William

Translate
MartinHanak24-Ruby III
24-Ruby III
Apr 9, 2015 12:55 PM UTC

William,

in Creo 2.0 the procedure works well.

You have to create three separate repeat regions.

For every region containing &fam.inst.param.value you have to apply filter &fam.inst.param.name == PARAMETERNAME.

Please upload your model&drawing. I can check it.

Martin Hanak

Translate
wjamieson1-VisitorAuthor
1-Visitor
Apr 9, 2015 2:00 PM UTC

For clarity's sake I'm trying to sort a 2D repeat region table by the values in any individual column of the table. Any help is appreciated. Thanks.

Translate
TomU
TomU23-Emerald IV
23-Emerald IV
Apr 9, 2015 3:47 PM UTC

You need to use a 2D region, not individual simple regions. Then you can sort by whichever row you want and everything will stay connected.

Repeat Region --> Sort Regions --> Pick the Region --> Add --> Forward (or Backward) --> Pick the row you want to sort by --> Done.

Translate
TomU
TomU23-Emerald IV
23-Emerald IV
Apr 9, 2015 3:51 PM UTC

By the way, it may not be obvious, but you can sort both the vertical direction and the horizontal direction.

forward.PNG

backwardd.PNG

mixed.PNG

Translate
wjamieson1-VisitorAuthor
1-Visitor
Apr 9, 2015 5:39 PM UTC

Does anybody know how to do this? I think this really needs to be a feature in Creo Parametric... It would be useful for creating tables organized by crucial properties, such as length, diameter, etc., which would be useful in a lot of applications, such as searching through a table by hand to find a part of specific length. Does anyone from PTC have a comment on this? I really appreciate any input.

Translate
MartinHanak24-Ruby IIIAnswer
24-Ruby III
Apr 9, 2015 9:16 PM UTC

William,

in attached Word document you can find information, how to create parametric sorted table of hex_jam_nut family table. Unfortunatelly the solution enables you to sort table according to CORNERS value or instance name, only.

You can also test "non-parametric solution":

  • open Family table editor and click File > Edit with Excel
  • open new empty Excel book, copy family table information into it and save it
  • insert this standalone Excel book into the drawing as linked object
  • every change in standalone Excel book will be transfered into the drawing, when you reopen it

Good luck

Martin Hanak

Translate
wjamieson1-VisitorAuthor
1-Visitor
Apr 10, 2015 12:47 PM UTC

Great solution Martin! It worked perfectly for me. Thanks a lot for your help!

Translate
TimoHügel5-Regular Member
5-Regular Member
Sep 16, 2026 2:56 PM UTC

Thank you very much; we created a table with a two-way lookup, and it works.

 

However, we don't want to sort by “&fam.inst.name,” but rather by “&fam.inst.param.value”—basically, by the ‘Length’ and “Width” columns.

 

Isn't that possible?

Translate
Terms & ConditionsAccessibility statement