[Manifold-l] Preserving sort order for exported table

[jburn_gis at cogeco.ca]

After you're done doing your splicing of the data, create a query (ANSI version):
select * into [new table] from [old table] order by [column 1], [column 2].

I think that'll do it for you.

>
>
>
> Seasons Greetings Listers.
>
>   Hopefully a simple question. I am using the data handling side of Manifold to help reformat some text files that I
> have been given (cheeky I know but Manifold has many facets).
>
>   Basically I'm going from a proprietary matrix format to a simple 3 column listing (origin_zone, destination_zone,
> cell_value). To do this I have split the data into separate tables and that cut and paste appended them back into a
> single master table with the correct formatting.
>
>   The problem is that I need to preserve a certain order in my data (sorting in ascending order first on column 1 and
> then column 2) in the .csv export table that I create. However, the sort command is (as I understand it) merely a
> transient view of the data and the export utility must use the primary key for sorting. Is there any quick and easy
> way around this?
>
>   Regards
>
> Paul Stanton MSc CMILT CSci MBCS CITP FRGS
>   Suffolk
>   England
>
>
> _______________________________________________
> Manifold-l mailing list
> Manifold-l at lists.directionsmedia.net
> http://www.directionsmedia.net/mailman/listinfo/manifold-l
>

--------------
James Burn AScT