Data Aggregation Method

[Owen]

Hi,

Is there a way to permanently the change the default data aggregation
methods?

When combining objects, etc, I need to change the method for some
fields from sum to value.

MapInfo remembers this for each session, but reverts back to the
defaults each time you reopen the programme.

Thanks,

Owen

[Natalie Bennett]

Yes - I would like value all the time for all my settings. I would also like to determine how I can make sure which object's data is brought in when using value. I have tried a number of methods, but cannot ascertain how MapInfo decides which object is the primary.

For example, if I select Object 1 first, then select all other objects I want to also add, shouldn't the values of Object 1 be what is used? I have tried it being the last selected, and also thought it may be the object with the highest or lowest Rowid, however it seems as though there is another method being used.

Sorry Owen, not your original question, but I would like to know if we can have more control over which object's data is used, as well as setting the defaults.

Nat

>>> Owen <owenj...@googlemail.com> 7/01/2011 8:34 pm >>>
Hi,

Thanks,

Owen

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com

[Peter Horsbøll Møller]

A few comments:

If you want to control what value to use, select one record, make that target and then select the remaining objects. Now use combine to merge them into one.

MapInfo stores similar things in the metadata section (as an example the settings used when thinning objects in a table), so I would recommend that you add this request to the PBBI Ideas Community: 

http://www.pbinsight.com/communities/pbbi-ideas-community/

Peter Horsbøll Møller
Pitney Bowes Business Insight - MapInfo

2011/1/9 Natalie Bennett <Natalie...@wellington.nsw.gov.au>

[Tim Rideout]

Hi Peter,

 

Could I make a suggestion that PBBI re-engineer the way that indexes work on the tab files.

 

I am working with some big files just now and it is a pain to have to remember to keep deleting any indexes.

 

If you, for example, use Append Rows to Table and the table you are appending to is both large and has one or more indexes, then even if only appending a couple of hundred objects could take an hour. Delete the index and the same Append completes in seconds. This suggests to me that the index is being updated after each object is appended. You could solve that by only updating the index after all objects have been appended.

 

You get the same issue with an Erase Outside if you are trying to clip out a small area from a bigger data set.

 

I had a example last week with a table with 200,000 polygons for the World where Erase Outside to clip out Europe had made virtually no progress after 6 hours with an index present, and finished in less than five minutes once I cancelled it, deleted the index and then ran the same thing again.

 

Regards

 

Tim

 

Dr Tim Rideout

Director

 

XYZ Win Awards - at the British Cartographic Society on June 10th our Postcode Sector Map - London won the Stanfords Award for Best Printed Map 2010, & at  International Map Trade Show on Feb 26th, the People's Map London won the Silver Award for Best Digital Product, Millennium House World Atlas won the Gold Award for best map book, the AGT GeoCentre World Map in Russian won the Gold Award for best flat map. All contain maps by XYZ.

Visit XYZ at IMTA Novara February 2011, Cape Town Book Fair June 2011.

 The XYZ Digital Map Company

Unit 9-11 Hardengreen Bus.Pk.
Dalhousie Road,
Dalkeith,
EH22 3NX

Tele: +44 (0) 131 454 0426
Mobile: +44 (0) 7766 825937
Fax: +44 131 454 0443
Email: tim.r...@xyzmaps.com
Web: www.xyzmaps.com

---

From: mapi...@googlegroups.com [mailto:mapi...@googlegroups.com] On Behalf Of Peter Horsbøll Møller
Sent: 10 January 2011 07:01
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Data Aggregation Method

 

A few comments:

If you want to control what value to use, select one record, make that target and then select the remaining objects. Now use combine to merge them into one.

 

MapInfo stores similar things in the metadata section (as an example the settings used when thinning objects in a table), so I would recommend that you add this request to the PBBI Ideas Community: 

http://www.pbinsight.com/communities/pbbi-ideas-community/

Peter Horsbøll Møller
Pitney Bowes Business Insight - MapInfo

2011/1/9 Natalie Bennett <Natalie...@wellington.nsw.gov.au>

Yes - I would like value all the time for all my settings.  I would also like to determine how I can make sure which object's data is brought in when using value.  I have tried a number of methods, but cannot ascertain how MapInfo decides which object is the primary.

[Owen]

Thanks for the replys

[Peter Horsbøll Møller]

Tim,

Very good points you raise here.

Again, feel free to raise this request on our new Ideas Community:

http://www.pbinsight.com/communities/pbbi-ideas-community/

This will allow other users to promote your idea

 
Peter Horsbøll Møller
Pitney Bowes Business Insight - MapInfo

2011/1/10 Tim Rideout <tim.r...@xyzmaps.com>

[Natalie Bennett]

Hi Peter,

I have been meaning to test this - and I have just realised what you
mean.

Once the first (primary) record is selected, i.e. the one with the data
which I want to retain as Value, I then need to go to Objects> Set
Target before selecting the remaining records to combine.

What I would like to know, is why the first record selected is not
automatically used for the data aggregation?

Regards

Nat

>>> Peter Horsbøll Møller <mapi...@horsboll-moller.dk> 10/01/2011
5:49 pm >>>

[Peter Horsbøll Møller]

Nat,

I guess it's because you might not always pick one record and then the others.

You could "multipick" all at once.

Another reason could be that a selection not has an order in which the records were selected.

Peter Horsbøll Møller
Pitney Bowes Business Insight - MapInfo

2011/1/25 Natalie Bennett <Natalie...@wellington.nsw.gov.au>