where condition

[sushil353]

hi experts

i want to aply where condition while loading data from a xl file

TEAM:

LOAD

TEAM_ID,

[TEAM NAME],

[TEAM COST]

FROM

[..\TESTDATAFILE.xls]

(

biff, embedded labels, table is Sheet1$);

i tried to apply where team_id>20 after from [..\TESTDATAFILE.xls]. but it is giving me error.

please help me.

thanks.

[#2]

Hi Sushil353

Try like this..

LOAD

TEAM_ID,

[TEAM NAME],

[TEAM COST]

FROM

(biff, embedded labels, table is Sheet1$)

Where Team_Id>20;

Otherwise, after written while reloading you can put filter.

[..\TESTDATAFILE.xls]

[#3]

dont read my first post. it was stupid due to qlikview editor.

try this..

LOAD

EnqID

,

Insys_Status

FROM

[Sample Data.xls]

(

biff, embedded labels, table is [CCP CAll Status$]

)

where

EnqID >20;