Order of rows in a table created from an attribute extraction.

[Anonymous]

I have extracted data from attributes to create this table. You can see that the order of the floor beams is incorrect. I know I can fix this by adding a zero in front of my single digits but that is not the look I want. Is there a way to rearrange the order without exploding the table?

[john.vellek]

Hi @Anonymous,

If you change your Marks to 01 instead of 1, 02 instead of 2, 03 instead of 3, etc does it sort properly?

Please select the Accept as Solution button if my post solves your issue or answers your question.

[john.vellek]

Hi @Anonymous

I am checking back to see if my post helped you with your problem or if you need additional assistance or information. Please add a post with how you decide to proceed and your results so other Community members may benefit.

Please hit the Accept as Solution button if my post fully solves your issue or answers your question.

[dgladfelter]

I don't know of an easy way to override the Data Extraction sort order. One admittedly obscure workaround I came up with was to create an Excel Data Link that has a Sort column; sort by that column, and then hide it.

Since it is such an obscure workaround, I recorded a Screencast attached to this response. http://autode.sk/2ha16GI

Hope that helps.

[M_Hensley]

Copy your table off to the side so you have two of them. In the original table pick on FB-10 then hold shift and pick on the span for FB-18. Hit the delete key to get rid of it. Now highlight FB-2 thru the span for FB-9. Hit CTRL+X to cut it out, put the cursor in the cell where FB-10 used to be and hit CTRL+V to paste it back. Now go to the copy table and highlight FB-10 thru 18 and CTRL+C to copy it then CTRL+V paste it into the original table under FB-9. Erase the copy and call it done.

[Anonymous]

Yes, it will sort when I put a 0 in front of the single digit. However this is not our company standard. I guess there is no good way to do this. I will just have to explode the table then manually move them.

[dgladfelter]

Did you have a chance to watch the screen cast I included in my previous reply

What you're trying to do is indeed possible (albeit through a workaround). You basically have to create a "sorting" column whose value is either A B C, or 01 02 03 in Excel. When you connect that to your Data Extraction table, you can first sort by it, and secondly hide it.