Compute Order Totals & Filter High-Value Orders
Created by
Adam Pearce
Compute a line-total field from price times quantity (lenient currency parsing included), then keep only orders above a value threshold, exported to Excel.
Dataset Filter & Transformnerolabs/dataset-filter-transform
Name
Email
Country
Revenue
+3 fieldsTextNumberBooleanListObject
Input
Data (inline)
orderId:A100+3
product:Widget+3
price:$19.99+3
qty:3+3
region:North+3
Transform steps (applied in order, before filtering)
op:compute
field:lineTotal
expression:price * qty
round:2
Filter conditions (applied after transforms)
field:lineTotal
operator:greaterOrEqual
value:50
Combine filters with:AND
Export file formats:xlsx
Output fields
Name
Email
Country
Revenue
Active
Signup date
Summary
Sign up on Apify01
Create your Apify account to access the Dataset Filter & Transform.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
