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)
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
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?
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
