topic Re: Generate ID-Column in QlikView

Generate ID-Column

Thu, 23 Jun 2016 10:26:09 GMT

Hallo Everyone,

i need your help pleace. I have 2 tables ZIP and Customers and i want to join the boht tables , but these do not have the same key. How can I get a key in table 'ZIP', so that they can access to Custumer?

ZIP( This table contains the coordinates of all the countries in the world)

Country	City	Latitude	Longitude

Customers

Customers	City

Thanks In advance

William

Re: Generate ID-Column

marcus_sommer — Thu, 23 Jun 2016 11:48:58 GMT

Is City not the same column in both tables?

- Marcus

Re: Generate ID-Column

PrashantSangle — Thu, 23 Jun 2016 11:50:59 GMT

Hi,

You have city column.

Join it on City column.

Regards

Re: Generate ID-Column

Thu, 23 Jun 2016 11:53:27 GMT

no this is not the same column.

Re: Generate ID-Column

marcus_sommer — Thu, 23 Jun 2016 13:47:49 GMT

Without a matching-field you won't be able to match these tables in a way which makes sense. Maybe you need to adjust one or both of these fields or join them before with other datas which make you able to generate such key-field.

Where are the differences between both city-fields?

- Marcus

Re: Generate ID-Column

Thu, 23 Jun 2016 13:57:19 GMT

Hey Marcus the Problem was resolved. I have the column 'Country' in the Customer table to excel exported and a new column 'Country_Code' generated in Excel and then a key between the ZIP table and the Customer table by mapping constructed

William