Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You can try like:
Load
empid ,
Amount,
[employee name]
From <>
where Amount>10000;
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
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;