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
Data
Data
Data
Table2.csv
name1
name2
name3
other
other
Data
Data
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.name1
Table2. name2
Table2.name3
other
other
Data
Data
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.
