Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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
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