Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

onkarkulkarni
New Contributor II

Remove synthetic keys in qliksense

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

3 Replies
chinnuchinni
Contributor III

Re: Remove synthetic keys in qliksense

then you you can use link table

thevingo
Contributor

Re: Remove synthetic keys in qliksense

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
New Contributor II

Re: Remove synthetic keys in qliksense

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

Community Browser