Load statement using where

Tue, 02 Jul 2013 20:12:50 GMT

Hey guys, I want to load a Task object from SalesForce where the Status does not equal "Complete" so that only incompleted tasks are loaded in. How do I do this?

[Task]:

LOAD

AccountId,

OwnerId,

Status as TaskStatus,

Subject as TaskSubject,

Type;

SQL SELECT AccountId,

CreatedById,

OwnerId,

Status,

Subject,

Type

FROM Task;

I know you are suppose to use a where statement.

Re: Load statement using where

Tue, 02 Jul 2013 20:24:58 GMT

Hi Suzan,

You can put a WHERE clause in your LOAD statement like below.

LOAD .......

SQL SELECT...

FROM....

WHERE status <> 'Complete'.

Hope it helps.

topic Load statement using where in QlikView

Load statement using where

Re: Load statement using where