Two same name of Column and different data

[sspawar88]

Hi,

I have a excel for states of India with cities and respective order amount.  i downloaded the KML for india but my excel having a state which is somewhere different spelled (due to my excel database mistake).

Datamodel matches the column name but data inside it looks different and not matches according to order amount.

have any way to do it?

[#2]

Hi Satish,

The columns will match until their name are same, irrespective of the data contained in them, it will obviously result in wrong data. In your case you would have to match the state names in your database and the KML file. You can use an Applymap for the same, Use the database state names as the key field and have the other column as the correct name(names mentioned in your KML file) as do an applymap on you database table.