topic Re: Hash Key in QlikView

Hash Key

ilanbaruch — Tue, 27 Oct 2015 11:48:08 GMT

Hi All,

I have 7 tables in my model all connected with account_id field and 3 of the tables contain also user_id field (currently commented).

I miss some of the calculations because I cant relay on account_id I need the user_id.

I know can be solved by LinkTable \ KeyTable but it will increase load time.. is there another way to load also user_id field?

thank you,

Ilan

MK_QSL — Tue, 27 Oct 2015 11:51:16 GMT

AutoNumber(account_id & '-' & user_id) as %Key

Anonymous — Tue, 27 Oct 2015 11:51:47 GMT

Can you share your data model ?

marcus_malinow — Tue, 27 Oct 2015 11:55:28 GMT

Ilan,

the typical approaches to this are either a link table or a concatenated fact table.

ilanbaruch — Tue, 27 Oct 2015 11:57:03 GMT

hi,

thank you for prompt answer.

after creating the new field (%Key), should I also load the two fields otherwise how will connect to the rest of the model?

marcus_malinow — Tue, 27 Oct 2015 11:59:24 GMT

Actually, on reflection, does your user id have a direct relationship to account id? e.g. is there a single user id associated with an account id?

If so, and if you have an Account dimension table, you could add your user id to that table.

ilanbaruch — Tue, 27 Oct 2015 12:09:01 GMT

user id have a direct relationship to account id- every account have a user id I have more users than accounts.

all starts with user and then part of them become accounts

sujeetsingh — Tue, 27 Oct 2015 12:24:14 GMT

Yes you load them if needed.