cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Highlighted
Participant

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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

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


Martin Hanák

View solution in original post

15 REPLIES 15

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

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



Martin Hanák

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

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

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

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


Martin Hanák

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

In the attached file (which is a modified file mentioned in the tutorial you showed) I have modified the numbers in the "Corners" parameter of the family table. When I sort the "Corners" column in the drawing, the numbers sort in order, however, the other columns do not change to match this sorting. I.E. only the numbers in the corners column rearrange, which causes the table to display incorrect values which are different than the original family table. Try sorting the "Corners" column in the drawing file to see what you get.

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

William,

it is logical, that if you sort one repeat region, then other will not sort. They are independent.

Martin Hanak


Martin Hanák

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

Then what's the point? I want to sort a table of a 2D repeat region by column values... If I did this I would simply ruin the integrity of the table. Please reference the initial question.

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

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.

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

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.

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

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

Announcements
LiveWorx Call For Papers Happening Now!