topic Association in Connectivity & Data Prep

Association

Mon, 30 May 2016 16:32:52 GMT

Hello,

I have two country fields that are named differently. Qlik Sense didn't create the association, so I'm wondering where I can make the manual association? I don't see any relationship menu like other tools have shown. I tried to click Associations in Data Manager, but it said "Did not find any association".

Any help is appreciated.

Re: Association

sunny_talwar — Mon, 30 May 2016 16:38:00 GMT

Rename one of them to be the same as the other one in both the tables

Re: Association

Mon, 30 May 2016 18:20:55 GMT

That's not the ideal solution as we would like to keep original naming convention. No way to manually associate in Qlik?

Re: Association

sunny_talwar — Mon, 30 May 2016 18:24:28 GMT

That's the only way to make associations. What you can do is may be this:

Table1:

LOAD Country,

OtherFieldNames

From Source1;

Table2:

LOAD CountryName,

CountryName as Country, //Use this for making associations

OtherFieldNames

From Source2;