topic Concatenate 2 optimized QVD's in QlikView

Concatenate 2 optimized QVD's

pascal_theurot — Mon, 03 Apr 2017 13:40:08 GMT

Hello,

When I concatenate the 2 attached QVD's I get unconsistant values in my Date field :

I don't have these values in my QVD's.

If I load the same 2 qvd's with the first one not optimized (where 1=1) I get the right values.

Any idea why I have this behavior ?

aarkay29 — Mon, 03 Apr 2017 13:52:50 GMT

I see that second QVD doesnot have the same fields as in the 1st qvd

Just try Join instead of Concatenate

pascal_theurot — Mon, 03 Apr 2017 14:02:55 GMT

Hi Aar,

If you change the script to have the same fields, you have the same behavior :

Fact:
LOAD Article,
    Date,
    Amount
FROM Fact1.qvd (qvd);


Concatenate


LOAD Article,
    Date,
    0 as Amount
FROM Fact2.qvd (qvd);

same with this code

Fact:
LOAD Article,
    Date
//    Amount
FROM Fact1.qvd (qvd);


Concatenate


LOAD Article,
    Date
FROM Fact2.qvd (qvd);

aarkay29 — Mon, 03 Apr 2017 14:45:20 GMT

The inconsistant values in Date field might be because qlikview unable to interpret the Dates

you can try like this to yield correct values with appropriate date intrepretation

Fact:

LOAD Article,

MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2))as Date,

Amount

FROM

Fact1.qvd (qvd);

Concatenate

LOAD

Article,

MakeDate(left(Date,4),Mid(Date,5,2),Right(Date,2))as Date,

0 as Amount

FROM

Fact2.qvd (qvd);

pascal_theurot — Mon, 03 Apr 2017 15:02:09 GMT

Aar,

The date in the first QVD is not interpreted as a date field using optimized load but correctly using a non optimized QVD load...

So, using a formula solve the case as I mentionned in my question.

But it's more about to understand the reason.

thanks Aar for your answer

Pascal