Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
AH
Creator III
Creator III

Link key question

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

1 Solution

Accepted Solutions
jonasheisterkam
Partner - Creator III
Partner - Creator III

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;

View solution in original post

4 Replies
jonasheisterkam
Partner - Creator III
Partner - Creator III

If you use Hash it is not a problem.

AH
Creator III
Creator III
Author

Hi Jonas,

Using Hash where exactly?

Shan

jonasheisterkam
Partner - Creator III
Partner - Creator III

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
Creator III
Creator III
Author

Thanks Jonas! Got it.

Shan