Qlik view key creation

[Saiteja1]

Hi ,

I have two tables table1 and table2

table1 have a single key (field) as id which contains 1 to 100 numbers

table2 have 4 fields 

1st field contains 1 to 30 numbers

2nd field contains 31 to 50 numbers

3rd field contains 51to 70 numbers

4th field contains 71 to 100 numbers

now I need to create new key by using these four fields and with that key i need to connect with table1 

can anyone  help me

thanks in advance 

[Or]

I'd suggest you create a new field which contains all of the values from the first four based on whatever logic defines them, e.g.

Coalesce(Field1,Field2,Field3,Field4) as Field5

And then use that as your key to the original table.