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

[wjamieson]

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!

[MartinHanak]

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

[wjamieson]

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

[MartinHanak]

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

[wjamieson]

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.

[MartinHanak]

William,

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

Martin Hanak

[wjamieson]

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.

[wjamieson]

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.

[TomU]

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.

[TomU]

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

[wjamieson]

Are you able to sort it by the "Corners" column? Thanks.

[TomU]

Actually...no. It looks like you can only sort by the outside row/column (instance name or parameter name), not by the values of those parameters.

[conosi1]

Please show more detail on how you sorted this.  Thanks

[wjamieson]

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.

[MartinHanak · Accepted solution]

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

[wjamieson]

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