Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Two same name of Column and different data


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?

1 Reply
Not applicable

Re: Two same name of Column and different data

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.

Community Browser