Qlik Sense doesn't Create Synthetic Key

Anonymous — Mon, 13 Nov 2017 09:00:09 GMT

Hello,

i'm facing an issue in qlik sense.
I have two .csv tables where there are three fields with the same name:

Table1.csv

name1

name2

name3

other

Data

Table2.csv

name1

name2

name3

other

Data

Now when loading the data in the data manager I would expect the creation of a synthetic key linking the two tables in this way:
name1 (Table1) -> name1 (Table2)
name2 (Table1) -> name2 (Table2)

name3 (Table1) -> name3 (Table2)

Unfortunately that doesn't happen.

Instead qlik sense automatically renames the field of the second table as:

Table2.csv

Table2.name1

Table2. name2

Table2.name3

other

Data

preventing the creation of the links.

I tried to rename the field manually (like Table2name1 -> name1) but I receive an error that the names should be unique.

Can someone explain me why this is happening?

Re: Qlik Sense doesn't Create Synthetic Key

shraddha_g — Mon, 13 Nov 2017 09:23:34 GMT

are you using data manager for adding data?

Re: Qlik Sense doesn't Create Synthetic Key

Anonymous — Mon, 13 Nov 2017 09:48:39 GMT

Thanks for answering.
Yes

Re: Qlik Sense doesn't Create Synthetic Key

shraddha_g — Mon, 13 Nov 2017 10:08:37 GMT

There in Data Manager you will get an option for Associations.

If you choose that option it will create a synthetic key.

Else by default in alias similar field name

topic Re: Qlik Sense doesn't Create Synthetic Key in Connectivity & Data Prep

Qlik Sense doesn't Create Synthetic Key

Re: Qlik Sense doesn't Create Synthetic Key

Re: Qlik Sense doesn't Create Synthetic Key

Re: Qlik Sense doesn't Create Synthetic Key