How to filter in script level?

[#1]

Hi

i have employess expenses data

empid ,Amount,employee name

but some each employee has many expenses first i want some of all the expenses and after that i want >10000 expenses

now i want to display ony >10000 expenses

how implement this is in script level not in desgin level

please

[PrashantSangle]

Hi,

Try like this,

Load

only(empid) as empid,

Sum(Amount) as Expenses,

Employee name

from tableName

where Sum(Amount)>10000

Group by Empoyee name

Regards

[senpradip007]

You can try like:

Load

     empid ,

     Amount,

     [employee name]

From <>

where Amount>10000;

[#4]

Hi,

for applying filter into Script Level you can use Where Clause

Like first Load all the data

All_Data :

Load *

From Source_Table;

Then use Resident Load

Filterd_data :

Load *

Resident All_Data

where expenses>10000;

Then Drop the All_Data Table :

Drop Table All_Data;

Regards,

Vivek

[Anonymous]

Use following script>>>

TEMP:

Load

empid as empid,

Sum(Amount) as Expenses,

[Employee name]

from <table name>

Group by empid,[Employee name];

NoConcatenate

Final:

LOAD * Resident TEMP

where Expenses>10000;