# The destination index is not updated by continuous transform

**URL:** https://discuss.elastic.co/t/the-destination-index-is-not-updated-by-continuous-transform/370526
**Category:** Elasticsearch
**Created:** [November 14, 2024, 7:47am UTC](https://discuss.elastic.co/t/the-destination-index-is-not-updated-by-continuous-transform/370526 "2024-11-14T07:47:09Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![realvie](https://avatars.discourse-cdn.com/v4/letter/r/8491ac/32.png) [@realvie](https://discuss.elastic.co/u/realvie)
#### Post date: [November 14, 2024, 7:47am UTC](https://discuss.elastic.co/t/the-destination-index-is-not-updated-by-continuous-transform/370526/1 "2024-11-14T07:47:09Z")

</div>

Hi Team, I have created a transform by api as follows:

```auto
PUT /_transform/product_transform
{
  "source": {
    "index": "all_requests"
  },
  "dest": {
    "index": "product_transform_index"
  },
  "pivot": {
    "group_by": {
      "product": {
        "terms": {
          "field": "product"
        }
      }
    },
    "aggregations": {
      "action_count": {
        "value_count": {
          "field": "action"
        }
      },
      "timestamp": {
        "max": {
          "field": "request_time"
        }
      }
    }
  },
  "frequency": "2s",
  "sync": {
    "time": {
      "field": "request_time",
      "delay": "1s"
    }
  }
}

```

and exec POST /\_transform/product\_transform/\_start, but the destination index is not updated on time and keep the original data forever.

source index: all\_requests, created script is as following:

```auto
PUT /all_requests
{
  "settings": {
    "number_of_shards": 1,
    "number_of_replicas": 1
  },
  "mappings": {
    "properties": {
      "product": { "type": "keyword" },
      "request_time": { "type": "date" },
      "response_time": { "type": "date" },
      "action": { "type": "keyword" }
    }
  }
}

```

ES&Kibana: 8.5.1  
Could you help me to solve this issue? Thanks.