Skip to main content
W
wjamieson1-Visitor
1-Visitor
April 8, 2015
Solved

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

  • April 8, 2015
  • 15 replies
  • 10042 views

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!

Best answer by MartinHanak

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

15 replies

M
MartinHanak24-Ruby III
24-Ruby III
April 9, 2015

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


W
wjamieson1-VisitorAuthor
1-Visitor
April 9, 2015

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

M
MartinHanak24-Ruby III
24-Ruby III
April 9, 2015

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

W
wjamieson1-VisitorAuthor
1-Visitor
April 9, 2015

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.

T
TomU23-Emerald IV
23-Emerald IV
April 9, 2015

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.

T
TomU23-Emerald IV
23-Emerald IV
April 9, 2015

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

W
wjamieson1-VisitorAuthor
1-Visitor
April 9, 2015

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.

M
MartinHanak24-Ruby IIIAnswer
24-Ruby III
April 9, 2015

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

W
wjamieson1-VisitorAuthor
1-Visitor
April 10, 2015

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

Terms & ConditionsAccessibility statement