Load statement using where

[#1]

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.

[#2]

Hi Suzan,

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

LOAD .......

SQL SELECT...

FROM....

WHERE status <> 'Complete'.

Hope it helps.