Qlik view key creation

Saiteja1 — Tue, 23 Aug 2022 07:48:33 GMT

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

Re: Qlik view key creation

Or — Tue, 23 Aug 2022 07:53:41 GMT

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.