Use sql where clause in loading excel file into QVDs

[#1]

hi ,

I was wondering if there is a possiblity to use sql where clause in loading excel file into QVDs , if there isn't is there such possibilities as using multiple search criteria , like OR and AND and Between ( Note : I'm just a beginner )

If you have any links that can help me with this kind of queries , it would be very helpful

Thank you

[Colin-Albert]

You can use a WHERE clause with Excel data.

The Excel wizard will take you through the options of how you can filter the data.

[anbu1984]

how to use where function for excel data source

[jagan · Accepted solution]

Hi,

You can use WHERE clause for Excel like SQL like this

TableName:

LOAD

*

FROM DataSource.xlsx

WHERE (Dim1= 'Some Value' AND Dim2 = 'Some Value') OR Dim3 = 'Some Value'

Regards,

Jagan.

[its_anandrjs]

Yes you can use WHERE OR AND like SQL in the load of excel or QVD as well as like

Tab1:

LOAD

Year,

Month,

Week

FROM Excel Source

WHERE (Month = 'Jan' AND Week = 3 ) OR Year = 2013;

Above is a example

Regards