Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | other | |||
---|---|---|---|---|---|---|---|
Data | Data |
|
|
|
Table2.csv
name1 | name2 | name3 | other | other | |||
---|---|---|---|---|---|---|---|
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.name1 | Table2. name2 | Table2.name3 | other | other | |||
---|---|---|---|---|---|---|---|
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?
are you using data manager for adding data?
Thanks for answering.
Yes
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