topic Re: Use sql where clause in loading excel file into QVDs in QlikView

Use sql where clause in loading excel file into QVDs

Tue, 15 Apr 2014 10:22:05 GMT

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

Re: Use sql where clause in loading excel file into QVDs

Colin-Albert — Tue, 15 Apr 2014 10:23:53 GMT

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.

Re: Use sql where clause in loading excel file into QVDs

anbu1984 — Tue, 15 Apr 2014 10:25:50 GMT

how to use where function for excel data source

Re: Use sql where clause in loading excel file into QVDs

jagan — Tue, 15 Apr 2014 10:28:23 GMT

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.

Re: Use sql where clause in loading excel file into QVDs

its_anandrjs — Tue, 15 Apr 2014 10:33:54 GMT

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