topic Re: Load with where in QlikView

Load with where

Tue, 03 Sep 2013 06:42:11 GMT

Is it possible to load from a DB with a where? I would like to load all data since 10.06.2013 and not older. Is that possible?

Re: Load with where

tresB — Tue, 03 Sep 2013 06:45:12 GMT

Very much possible. Try like:

Select * From <DB> Where DateField >= '10.06.2013'

Now here you have to ensure that the date format is similar in DB.

Re: Load with where

dmohanty — Tue, 03 Sep 2013 06:52:00 GMT

LOAD

Select

From SchemaName.TableName

WHERE Date >= '10.06.2013'

IMP: Your Date Format should be same both in QlikView and DataBase

Re: Load with where

Tue, 03 Sep 2013 09:24:22 GMT

I converted the Date with Load Date(Floor(DATETIME)) as Date..

can i also take this date?

Re: Load with where

dmohanty — Tue, 03 Sep 2013 09:27:43 GMT

Yes,

You can take both the fields: Original and Transformed. But make sure that both the fields are of different name, otherwise it would throw error. Make it DATE and NEW_DATE, like wise.

Re: Load with where

Tue, 03 Sep 2013 09:31:38 GMT

I have now:

LoadedTable:

Load *,

Date(Floor(DATETIME)) as Date;

ODBC CONNECT TO [xxx]

SQL SELECT action,

ID,

DATETIME

FROM xx."yy"

Where Date >= '19.08.2013';

Then I get the error Expression missed

Re: Load with where

tresB — Tue, 03 Sep 2013 09:33:50 GMT

Put the where clause in SQL select part and do the format changing in the RELOAD part using qv functions and there is no restriction of how many times you are pulling the same field (must be with different name) like below:

Load

Date(Floor(DATETIME)) as Date,

Month(DATETIME) as Month,

Year(DATETIME) as Year ;

SQL SELECT

from <>;

Re: Load with where

tresB — Tue, 03 Sep 2013 09:35:36 GMT

Where Date >= '19.08.2013'; // this is wrong, try:

Where DATETIME >= '19.08.2013'; // but be careful about the timestamp format (as i already mentioned earlier)

Re: Load with where

Tue, 03 Sep 2013 09:51:10 GMT

My code now:

ODBC CONNECT TO [xx] (xxxx);

Load Date(Floor(DATETIME)) as Date;

SQL SELECT ACTION,

ID,

DATETIME

WHERE Date >= '19.08.2013'

FROM XX."yy";

DATETIME is 10.08.2013 12:08:10.00000000 so i cant say where DATETIME >=

Re: Load with where

tresB — Tue, 03 Sep 2013 09:56:14 GMT

Try this:

ODBC CONNECT TO [xx] (xxxx);

Load Date(Floor(DATETIME)) as Date;

SQL SELECT ACTION,

ID,

DATETIME

WHERE DATETIME >= '19.08.2013 00:00:00.00000000'

FROM RORC."RORC_ORDERS_FEED";

Re: Load with where

Tue, 03 Sep 2013 10:53:02 GMT

Then i get the error "Schlüsselwort FROM nicht an erwarteter Stelle gefunden" -> Code(?) word not found at the correct position

Re: Load with where

tresB — Tue, 03 Sep 2013 11:01:43 GMT

Try: // this will compromise your performance though

ODBC CONNECT TO [xx] (xxxx);

Load Date(Floor(DATETIME)) as Date Where Date(DATETIME,'DD.MM.YYYY')>='19.08.2013';

SQL SELECT ACTION,

ID,

DATETIME

WHERE

FROM RORC."RORC_ORDERS_FEED";