topic Pull data in QlikView

Pull data

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

From Log files I can extract the data easily based on the

where condition like below

Load * from

<path>

where Sales>=10000 and Product='Mens appearals' and

date>=Jan-2016;

But

If want to extract the same data from databases

such as

.mdb, sql server,oracle and whatever.

How can we do that???

Any ideas please suggest.

Re: Pull data

Mon, 09 May 2016 20:12:43 GMT

when pulling the data from databases after establishing the connection string you can use the where clause at the end of the statement similar to the thing you do in databases. This filtering will not be happening in Qlik instead the filtering is applied while pulling the data from the databases.

Re: Pull data

ziadm — Mon, 09 May 2016 23:28:12 GMT

Similar to SQL syntax to query a table or view

Load

Field1,

Field2,

Field3;

SELECT Field1,

Field2,

Field3

FROM TableName

Where Field1 > 0 ;

Re: Pull data

Tue, 10 May 2016 03:34:22 GMT

Thanks for your suggestions.

I tried the same thing before I posted this.

But where condition is not working to restrict the data from .mdb

Only it works when to ristrict the data from log files.

I don't know where am wrong.

Please suggest any more ideas.

Re: Pull data

Anonymous — Tue, 10 May 2016 04:43:07 GMT

ATFER LOAD THE DATA TO GIVE THE WHERE CONDITION YOU CAN GET THE O/P

Re: Pull data

avinashelite — Tue, 10 May 2016 07:34:14 GMT

you could do it SQL or in Qlikview .....

LOAD *;

SQL SELECT *

from

from table

where

Sales>=10000 and Product='Mens appearals' and

date>=Jan-2016;

LOAD *

where

Sales>=10000 and Product='Mens appearals' and

date>=Jan-2016

;

SQL SELECT *

from

from table;