Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is the sum function supported in where condition of Load script
If it is supported can we use
Load id from salary where sum(gross) > 100000 Group By id
If not what is the alternative for this requirement
Hi,
You can use Preceding load to filter data after aggregation:
Data:
LOAD
ID
Where gross>10000;
LOAD
ID,
SUM(gross) AS gross
Resident Data_TMP
Group By ID;
Regards,
Vitalii
Hi,
You can use Preceding load to filter data after aggregation:
Data:
LOAD
ID
Where gross>10000;
LOAD
ID,
SUM(gross) AS gross
Resident Data_TMP
Group By ID;
Regards,
Vitalii