D
dayhox
So I am attempting to normalize a database. I've brought the values
into an excel sheet to help with the replace functions. MySQL may have
similar functionality, but am too unfamiliar with it. basically I have
9800 rows of values, of those there are roughly 3000 unique entries.
those 3000 unique entries have been given a numeric value so model_id
= 1 - unique = 2.3CL/3.0CL 4Cyl / Auto(L4) --- model_id =2 - unique =
2.3CL/3.0CL 4Cyl / Manual(M5) and so on.
So:
Column A holds all 9800 entries
Column C holds the 2800 id #'s
Column D holds the 2800 unique values
For each row in column A it should be replaced with the number in
column C Where Column D = column A
Thanks for your time and assistance.
day
into an excel sheet to help with the replace functions. MySQL may have
similar functionality, but am too unfamiliar with it. basically I have
9800 rows of values, of those there are roughly 3000 unique entries.
those 3000 unique entries have been given a numeric value so model_id
= 1 - unique = 2.3CL/3.0CL 4Cyl / Auto(L4) --- model_id =2 - unique =
2.3CL/3.0CL 4Cyl / Manual(M5) and so on.
So:
Column A holds all 9800 entries
Column C holds the 2800 id #'s
Column D holds the 2800 unique values
For each row in column A it should be replaced with the number in
column C Where Column D = column A
Thanks for your time and assistance.
day