topic Re: Synthetic key in cross table? in QlikView

Synthetic key in cross table?

Tue, 11 Mar 2014 12:12:40 GMT

Hi,

Please find attached. can anyone let me know how to remove synthetic keys? in cross table.

Thanks.

Re: Synthetic key in cross table?

Tue, 11 Mar 2014 12:25:31 GMT

Please can anyone help me.

Re: Synthetic key in cross table?

Tue, 11 Mar 2014 12:44:00 GMT

Please find attached.

Re: Synthetic key in cross table?

its_anandrjs — Tue, 11 Mar 2014 13:01:47 GMT

Hi,

Identify which is the most important key and fields in the tables and keep those other wise remove unwanted keys or rename those keys for use on other references.

Another way is make composite key with synthetic fields by identifying those.

Eg.

Table1 Field1&Field2&Field3 as Key1

Table2 Field1&Field2&Field3 as Key1

Thanks & Regards

Re: Synthetic key in cross table?

ashwanin — Tue, 11 Mar 2014 13:22:18 GMT

use Concatenate

or else provide the excel file.

Re: Synthetic key in cross table?

Tue, 11 Mar 2014 13:37:03 GMT

Thanks.