Select query on QVD

[#1]

hi all,

can we have a select query on a QVD.

like first load the qvd

load * from qvd           and then

select few columns from qvd

is it possible

thanks

[nilesh_gangurde]

if you want few columns from qvd, instead of using "Load * from Qvd"

use the "Load (Column names) from Qvd".

-Nilesh

[kaushiknsolanki]

Hi,

     You can not use the Select query when getting data from QVD, it is used only when you are fetching data from Databases like Oracle, mysql and so on.

     But yes you can filter the data based on some condition like you do in Select Query when you are fetching data from QVD;

Regards,

Kaushik Solanki

[#4]

Thanks Kaushik.

Can we use Sum function along with if statement while loading data from QVD??

[kaushiknsolanki]

Hi,

     Yes you can do. Something like this.

     Load if(Country = 'INDIA', sum(Amount)) as INDIA_SALES

     From XYZ;

Regards,

Kaushik Solanki

[er_mohit]

try this.Suppose in A table ur column is a to z which is fetch from qvd.......

A:

load * from qvd;

B:

load a,b,c

resident A ;

drop table A;