topic Re: Help with load statement QVD in QlikView

Help with load statement QVD

helen_pip — Tue, 12 Feb 2013 14:32:57 GMT

Hello

My mind has gone blank, and was wondering if someone could help me

If I want load all from a QVD I know I have to write

Table1:

LOAD * FROM xxxxxx/xxx/xxxx.qvd

However If I want to do a calculation on a field and still load all from a qvd, how do I write this

I.e.

LOAD

Left(arrival_date,3) as date

FROM xxxxxx/xxx/xxxx.qvd

Yet I have completely forgotten or perhaps have never known how do this

Can anyone help?

Thanks

Helen

Re: Help with load statement QVD

alexandros17 — Tue, 12 Feb 2013 14:41:30 GMT

You have to

myQVD_tmp:

LOAD

FROM xxxxxx/xxx/xxxx.qvd;

myQvd:

noconcatenate

LOAD

Left(arrival_date,3) as date,

.....

Resident myQVD_tmp;

Drop table myQVD_tmp;

Re: Help with load statement QVD

SunilChauhan — Tue, 12 Feb 2013 14:46:42 GMT

i thing there is no use of noconcatenate. because first table droped already

myQVD_tmp:

LOAD

FROM xxxxxx/xxx/xxxx.qvd;

myQvd:

LOAD

Left(arrival_date,3) as date,

Resident myQVD_tmp;

Drop table myQVD_tmp;

hope this helps

Re: Help with load statement QVD

helen_pip — Tue, 12 Feb 2013 14:49:53 GMT

Hello

Thank you for your replies

So there is no way that I can just load the QVD just once into my QVW.

I always have to do a resident load and drop table technique?

I cannot do anything like I suggested above?

LOAD

Left(arrival_date,3) as date

FROM xxxxxx/xxx/xxxx.qvd

I guess resident loads and dropping tables is the only way eh

Thanks

Helne

Re: Help with load statement QVD

SunilChauhan — Tue, 12 Feb 2013 14:52:24 GMT

yes you can but make sure there should not exist date in qvd.

if you have two date in same table ,result in unique field error

LOAD

Left(arrival_date,3) as date

FROM xxxxxx/xxx/xxxx.qvd

hope this helps