Store qvd table with certain conditon.

[Energetic]

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 ;

[shivanandk]

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.

[juraj_misina]

What is the error you are facing? It's not clear from your post.

[Energetic]

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!

[Energetic]

I resolved it . Thanks.