Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Generate ID-Column

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)

CountryCityLatitudeLongitude

Customers

CustomersCity

Thanks In advance


William

5 Replies
marcus_sommer
Not applicable

Re: Generate ID-Column

Is City not the same column in both tables?

- Marcus

PrashantSangle
Not applicable

Re: Generate ID-Column

Hi,

You have city column.

Join it on City column.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

Re: Generate ID-Column

no this is not the same column.

marcus_sommer
Not applicable

Re: Generate ID-Column

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

Not applicable

Re: Generate ID-Column

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