Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense doesn't Create Synthetic Key

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 name3otherother
DataData
Data
Data
Data

Table2.csv

name1 name2 name3otherother
DataData
Data
Data
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.name1Table2. name2Table2.name3otherother
DataData
Data
Data
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?

3 Replies
shraddha_g
Partner - Master III
Partner - Master III

are you using data manager for adding data?

Anonymous
Not applicable
Author

Thanks for answering.
Yes

shraddha_g
Partner - Master III
Partner - Master III

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