topic Re: I have in QlikView

I have

paulyeo11 — Tue, 10 Jun 2014 05:14:01 GMT

Hi All

i have 10 QVD file all the same , it work fine for 2 year. Total i create another unqie table when i Concatenate with the 10 QVD file , i the whole database become very slow and not working.

This new QVD table have all the same field with 10 QVD table. except 1 additional field name i add .I try to use NoConcatenate , it also never help to solve the problem. Can some one give me suggestion ?

PRICE:

load * from $(vQVDPath)BECKHOFF.qvd (qvd);

Concatenate

load * from $(vQVDPath)HAKKO.qvd (qvd);

Concatenate

load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

Concatenate

load * from $(vQVDPath)GE.qvd (qvd);

Concatenate

load * from $(vQVDPath)HMS.qvd (qvd);

Concatenate

load * from $(vQVDPath)KEB.qvd (qvd);

Concatenate

load * from $(vQVDPath)REDLION9.qvd (qvd);

Concatenate

load * from $(vQVDPath)SCM.qvd (qvd);

Concatenate

load * from $(vQVDPath)KINCO.qvd (qvd);

Concatenate

load * from $(vQVDPath)POWER_SUPPLY.qvd (qvd);

// below table create problem.

noConcatenate

load * from $(vQVDPath)LOCAL_TID.qvd (qvd);

Re: I have

kiranmanoharrode — Tue, 10 Jun 2014 05:38:14 GMT

Give Table name to 11th table,

Use below script:

PRICE:

load * from $(vQVDPath)BECKHOFF.qvd (qvd);

Concatenate

load * from $(vQVDPath)HAKKO.qvd (qvd);

Concatenate

load * from $(vQVDPath)MITSUBISHI.qvd (qvd);

Concatenate

load * from $(vQVDPath)GE.qvd (qvd);

Concatenate

load * from $(vQVDPath)HMS.qvd (qvd);

Concatenate

load * from $(vQVDPath)KEB.qvd (qvd);

Concatenate

load * from $(vQVDPath)REDLION9.qvd (qvd);

Concatenate

load * from $(vQVDPath)SCM.qvd (qvd);

Concatenate

load * from $(vQVDPath)KINCO.qvd (qvd);

Concatenate

load * from $(vQVDPath)POWER_SUPPLY.qvd (qvd);

// below table create problem.

noConcatenate

LOCAL_TID:

load * from $(vQVDPath)LOCAL_TID.qvd (qvd);

Re: I have

jonathandienst — Tue, 10 Jun 2014 05:49:32 GMT

Paul

If you are adding the last load into a separate table, you are creating a synthetic key with all the fields in the existing table. This will likely have a severe performance impact. Rather concatenate the new table to the existing table. The new field will be null for all the existing sources. You will need to force the concatenation with Concatenate as the field list is not identical.

HTH

Jonathan

Re: I have

paulyeo11 — Tue, 10 Jun 2014 06:05:32 GMT

Hi All

Thank you for your advise. but i still unable resolve the issue.

Enclosed is my 3 QV doc .

1. first 10 table QVD . ( working fine ).

2. last table QVD. ( working fine ).

3. combine of above 2 table ( not working ).

Paul

Re: I have

paulyeo11 — Tue, 10 Jun 2014 06:55:19 GMT

Hi All

it was my mistake , in my last table i accidently create a field name Currency_P.

in the first 10 table it was created by :-

LOAD * INLINE [

Currency_P, RATE_P

SG, 1

MY, 2.65

INDO, 9500

THAI, 25

];

So my last table field name force the whole table Currency_P = INDO

I manage to find out when I try to create Local Product Table for MY , same thing happen , then i know where i make the mistake.

Thank you , now i can move on.

Paul