Hi,
I don't think that your problem is in linking your XLS table to MIP.
Because you have a numerical identificator for the ward both in your XLS
file and in MIP.
Your problem is that of aggregating your XL data by ward number before
linking them to MIP (aka computing the number of inhabitants for all the
house number in the ward). You can do that in excel. You have to use a
procedure/command from the DATA menu, which in my French version is named
"Rapport de tableaux crois�s dynamiques" which should be translated in
English by "Dynamic Crosstables Reports" or something like that. Once
you have aggregated your data in XLS, you'll be able to link them easily
to MIP.
Christiane
Hoping this will help
T�l�chargez gratuitement Lausanne d�chiffr�e, 4 pages d'actualit�
statistique
Commandez Lausanne � la carte, le nouvel atlas th�matique lausannois
Christiane Roh - Section Statistique Lausanne
Statistique Lausanne - SCRIS
Service cantonal de recherche et d'information statistiques
Rue de la Paix 6, CH-1014 Lausanne
t�l.: +41(021) 316 29 51
fax : +41(021) 316 29 50
Autres sites � consulter :
SCRIS
Observatoire du logement
Harsha <[EMAIL PROTECTED]>
09.06.2005 12:31
Pour : mapinfo-l directionsmag
<[email protected]>
cc :
Objet : MI-L Linking charecter filed in internal database with
numeric fields of external database
Hello all,
I have a problem with me in attaching
external database.
I have a map of a city which is divided in to
small blocks.
The data bse is as follows for the map.
Ward No Houseno Area
1 1-10 123
2 11-20 1234.34
so on..this is a huge data.
Wardno - Numeric
Houseno - Charecter
My external databs in .xls format is as follows
Ward No Houseno Noofresidents
1 1 4
1 2 5
2 11 2
the data goes so on.....
Wardno - Numeric
Houseno - numeric
Now how can I attach the external databse as
I have 2 problems with me
1. My internal data of Houseno's is charecter and it
is not continuous. It represents a group of data
1-10,11-20 so on. And my external data is contious for
houssno's 1,2,3---10 ; 11,12,13---20 etc.
2. Both of the data types for the filed i need to
create a link are not of same data type.
Can any one tell me solution for this,
actually I was working on Arcview3x upto now, I placed
this topic in the Arcview list found no solution.
Thinking Mapinfo a better tool in in
attaching data, i want to find out from you people how
to do it.
Regards,
Harsha
Harsha
__________________________________________________________
Free antispam, antivirus and 1GB to save all your messages
Only in Yahoo! Mail: http://in.mail.yahoo.com
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16750
