QVD creation efficiency

[Anonymous]

I currently use the below 3 step process to create qvd. My guess is that this 3 step process could be improved by something along the lines of 'select .....from.... into file.qvd', which is a single step process. Any thoughts?

Thanks,

Dinesh.

[table_x]:

select column_a

    , column_b

from table_x

;

STORE table_x into table_x.qvd;

DROP table table_x;

[nagaiank]

The syntax of 'SELECT' in QlikView script is:

select [ all | distinct | distinctrow | top n [ percent ] ] *fieldlist

from tablelist

[ where criterion ]

[ group by fieldlist [ having criterion ] ]

[ order by fieldlist [ asc | desc ] ]

[ ( inner | left | right | full ) join tablename on fieldref = fieldref

]

It does not include using 'INTO'

[Anonymous]

I know!!! probably more of a gripe from me!! Maybe in the future enhancements !!!