Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to save QVD file when the following conditions are met.
I tried following scripts but failed.
if YesOrNo= 'Yes' then
ALL_TABLE:
LOAD
country
division
Cluster,
YesOrNo
FROM [lib://QVD\*.qvd]
(qvd)where YesOrNo= 'Yes';
endif
store ALL_TABLE into 'lib://QVD\ ALL_TABLE .qvd';
drop table ALL_TABLE ;
Here is one way
ALL_TABLE:
LOAD
country
division
Cluster,
YesOrNo
FROM [lib://QVD\DataFile.qvd]
(qvd)where YesOrNo= 'Yes';
If NoOfRows('ALL_TABLE') > 0 Then
store ALL_TABLE into 'lib://QVD\ ALL_TABLE .qvd';
End If
drop table ALL_TABLE ;
Replace * with your name of the QVD file (like Datafile.qvd) to be more specific.
What is the error you are facing? It's not clear from your post.
ALL_TABLE:
LOAD
country
division
Cluster,
YesOrNo
FROM [lib://QVD\*.qvd]
(qvd)where YesOrNo= 'Yes';
store ALL_TABLE into 'lib://QVD\ ALL_TABLE .qvd';
drop table ALL_TABLE ;
it works!
I resolved it . Thanks.