topic Re: Link key question in QlikView

Link key question

AH — Fri, 30 Jan 2015 19:43:21 GMT

Hi,

If i make a key using couple of fields and some one of the field has Null values in it. Then does that make a good key which will connect the tables?

Thanks,

Shan

jonasheisterkam — Fri, 30 Jan 2015 19:48:04 GMT

If you use Hash it is not a problem.

AH — Fri, 30 Jan 2015 19:50:39 GMT

Hi Jonas,

Using Hash where exactly?

Shan

jonasheisterkam — Fri, 30 Jan 2015 20:08:14 GMT

If I understand you right that you have tow table wich connects over more then 1 field? Now you look to get a function to build a correct connection.

TABLE1:

Load

Hash256("1KeyPartA","1KeyPartB","1KeyPartC","1KeyPartD") as Key,

"1KeyPartA",

"1KeyPartB",

"1KeyPartC",

"1KeyPartD",

"1Value"

resident Tab1;

TABLE2:

Load

Hash256("2KeyPartA","2KeyPartB","2KeyPartC","2KeyPartD") as Key,

"2KeyPartA",

"2KeyPartB",

"2KeyPartC",

"2KeyPartD",

"2Value"

resident Tab2;

AH — Fri, 30 Jan 2015 20:10:42 GMT

Thanks Jonas! Got it.

Shan