In Line

[upaliwije]

Hi,

I have in data table a field by the name of MAKE . I want to reclassify it the format given below  and make new filed MAKE1

I used the load in line command to do this. But some of make are duplicated.

Eg:  HONDA  is categorized both under MAKE and MAKE1 fields. Can you pls tell me whether can use better method other than Load in Line

MAKE	MAKE1
PEUGEOT	PEUGEOT
ASHOK LEYLAND	ASHOK LEYLAND
NOMAD ZOTYE	NOMAD ZOTYE
CHERRY QQ	CHERRY QQ
HYHUNDAI	HYHUNDAI
HONDA	HONDA
TATA	TATA
MAZDA	MAZDA
PERODUA	PERODUA
HUMBER	OTHERS
CITROEN	OTHERS
JOYLONG	OTHERS
MAHENDRA	OTHERS
FIAT	OTHERS
OPEL	OTHERS
FOTON	OTHERS
ASHOK LEYLAND	OTHERS
HYHUNDAI	OTHERS
MATRIX	OTHERS

[avinashelite]

Don't you have any key field with you could tag the values with ? because if others   belong to all the types then how you will identify to which type it belongs ...their should be an identifier rite ?