Create a new table same as YOURTABLE (let's say SECONDTABLE)
Then Run this MB
dim k,num,zc as integer
fetch first from YOURTABLE
do while not eot(YOURTABLE)
num = YOURTABLE.col2
zc = YOURTABLE.col1
for k = 1 to num
insert into SECONDTABLE (col1,col2) values (zc,1)
next
fetch next from YOURTABLE
loop
commit table SECONDTABLE
Regards...
Ahmet Dabanli..
----- Original Message -----
From: Kamel, Jennifer <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 25, 2000 10:26 PM
Subject: MI duplicating records
Hi All!
I often get spreadsheets that have two columns, one containing the zip code
and the second containing a number indicating the number of people in that
zip code.
Is there a way to duplicate the number of records a zip code has according
to the number in the second column?
Example:
I get:
Zip NO
92691 5
I want:
ZIP
92691
92691
92691
92691
92691
Thank you!
Jennifer K. Kamel
Resource Administrator
Julien J. Studley, Inc.
10960 Wilshire Blvd., Suite 1700
Los Angeles, CA 90024
P 310-444-1013
F 310-444-1099
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]