Link key question

[AH]

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]

If you use Hash it is not a problem.

[AH]

Hi Jonas,

Using Hash where exactly?

Shan

[jonasheisterkam · Accepted solution]

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]

Thanks Jonas! Got it.

Shan