Pull data

[#1]

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.

[#2]

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.

[ziadm]

Hi

Similar to SQL syntax to query a table or view

Load

Field1,

Field2,

Field3;

SELECT Field1,

Field2,

Field3

FROM TableName

Where Field1 > 0 ;

[#4]

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.

[Anonymous]

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

[avinashelite]

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;

OR

LOAD *

where 

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

date>=Jan-2016

;

SQL SELECT *

from

from table;