Help with load statement QVD

[helen_pip]

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

[alexandros17]

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;

[SunilChauhan]

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

[helen_pip]

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

[SunilChauhan]

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