How to avoid Synthetic key when loading from QVD

david_ze — Thu, 07 Jul 2011 08:35:44 GMT

hi all,

I'm loading data from 3 QVD files (xxCUSTOMERS.QVD) with the same fields.

CUSTOMERS_DATA:

LOAD * from *CUSTOMERS.qvd (qvd);

After loading all files the system creates 3 tables CUSTOMERS_DATA with Synthetic keys.

Could you advice me on how should I load the files into one table (CUSTOMERS_DATA).

Thanks in advanced.

David

Re: How to avoid Synthetic key when loading from QVD

Miguel_Angel_Baeyens — Thu, 07 Jul 2011 08:53:56 GMT

Hello David,

If they have the same fields, there must be some problem anywhere, since QlikView concatentates implicitly when two orm ore tables in the script have the same number and name of fields (note that QlikView is case sensitive for both field names and values), unless NOCONCATENATE is used.

Anyway, you can force several tables to be concatenated explicitly preceding the second and onwards LOAD keywords with CONCATENATE. However, in this case you cannot use the wildcard in the FROM part:

Table:
LOAD *
FROM File1.qvd (qvd);
CONCATENATE LOAD *
FROM File2.qvd (qvd);
CONCATENATE LOAD *
FROM File3.qvd (qvd);

Are you only loading those three tables? If you script has more tables, it may be one of these what is causing the synthetic keys. QlikView creates a synthetic key whenever two or more tables have two or more fields named alike.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

topic How to avoid Synthetic key when loading from QVD in QlikView

How to avoid Synthetic key when loading from QVD

Re: How to avoid Synthetic key when loading from QVD