Discussion board where members can get started with Qlik Sense.
I have two spreadsheets with with 4 common columns W,X,Y,Z
I am loading both spreadsheets in table A and B respectively.
When I load both the tables synthetic key is formed for W,X,Y,Z.
I want to remove the synthetic key. I am using all of the above 4 columns as filters so I cannot use Aliasing fields name.
then you you can use link table
If both tables have so much common columns, can you force concatenate both into 1
Rename fields & use hashkey instead to link the tables
You can break your tables into smaller
PS: If you're data results/values are right, then synthentic key is not a problem
Yes I can see the results are as expected as of now.
However I was worried if I got multiple spreadsheets to load then it would make data model a bit complex.
table 1 has total 21 columns and table 2 has total 11 columns.
I am not sure about haskey approach, I will explore it.