Remove synthetic keys in qliksense

[onkarkulkarni]

Hello all,

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.

Please suggest.

Thanks

[chinnuchinni]

then you you can use link table

[thevingo]

Hi

If both tables have so much common columns, can you force concatenate both into 1

or

Rename fields & use hashkey instead to link the tables

or

You can break your tables into smaller

or..

PS: If you're data results/values are right, then synthentic key is not a problem

[onkarkulkarni]

Thanks Govind,

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.

Regards,

Onkar