# Filter US Leads & Clean Fields

**Use case:** 

Filter scraped leads to one country and value threshold, trim/lowercase emails, cast a currency string to a number, and build a summary field, in one Actor run.

## Input

```json
{
  "data": [
    {
      "name": "  jane doe ",
      "email": "JANE@Example.com",
      "country": "US",
      "revenue": "$12,500.00",
      "active": "yes",
      "signupDate": "2026-03-14"
    },
    {
      "name": "Bob Smith",
      "email": "bob@example.com",
      "country": "GB",
      "revenue": 400,
      "active": "no",
      "signupDate": "2026-05-02"
    },
    {
      "name": "Ana Silva",
      "email": "ana@example.com",
      "country": "BR",
      "revenue": "2,300",
      "active": "yes",
      "signupDate": "2026-06-19"
    },
    {
      "name": "  Chen Wei",
      "email": "chen@example.com",
      "country": "US",
      "revenue": "n/a",
      "active": "yes",
      "signupDate": "2026-07-01"
    },
    {
      "name": "Sam Lee",
      "email": "sam@example.com",
      "country": "US",
      "revenue": 9800,
      "active": "yes",
      "signupDate": "2026-08-05"
    }
  ],
  "transforms": [
    {
      "op": "trim",
      "field": "name"
    },
    {
      "op": "lowercase",
      "field": "email"
    },
    {
      "op": "cast",
      "field": "revenue",
      "to": "number"
    },
    {
      "op": "addField",
      "field": "summary",
      "template": "{{name}} ({{country}}) - {{email}}"
    }
  ],
  "filters": [
    {
      "field": "country",
      "operator": "equals",
      "value": "US"
    },
    {
      "field": "active",
      "operator": "equals",
      "value": "yes"
    },
    {
      "field": "revenue",
      "operator": "greaterOrEqual",
      "value": 1000
    }
  ],
  "filterCombineMode": "AND",
  "caseSensitiveFilters": false,
  "lenientNumbers": true,
  "exportFormats": [
    "csv",
    "xlsx"
  ]
}
```

## Output

```json
{
  "name": {
    "label": "Name",
    "format": "text"
  },
  "email": {
    "label": "Email",
    "format": "text"
  },
  "country": {
    "label": "Country",
    "format": "text"
  },
  "revenue": {
    "label": "Revenue",
    "format": "number"
  },
  "active": {
    "label": "Active",
    "format": "text"
  },
  "signupDate": {
    "label": "Signup date",
    "format": "text"
  },
  "summary": {
    "label": "Summary",
    "format": "text"
  }
}
```

## About this Actor

This example demonstrates how to use [Dataset Filter & Transform](https://apify.com/nerolabs/dataset-filter-transform) with a specific input configuration. Visit the [Actor detail page](https://apify.com/nerolabs/dataset-filter-transform) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
This Task's input is already configured above — use it as-is rather than inventing a new one.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/nerolabs/dataset-filter-transform.md

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).