# Transform api : Can't find destination index in kibana

**URL:** <https://discuss.elastic.co/t/transform-api-cant-find-destination-index-in-kibana/233732>\
**Category:** Kibana\
**Created:** [May 21, 2020, 12:05pm UTC](https://discuss.elastic.co/t/transform-api-cant-find-destination-index-in-kibana/233732 "2020-05-21T12:05:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![elisavet](https://avatars.discourse-cdn.com/v4/letter/e/258eb7/32.png) [@elisavet](https://discuss.elastic.co/u/elisavet)\
**Post date:** [May 21, 2020, 12:05pm UTC](https://discuss.elastic.co/t/transform-api-cant-find-destination-index-in-kibana/233732/1 "2020-05-21T12:05:40Z")

</div>

Hi!

I run the follwoing query to create a new index using the TRANSFORM API . While the query runs correctly, I can't find the new index (in my case **kibana\_sample\_data\_ecommerce\_transform\_210520** ) in the kibana UI.

Can you please help me?

The query I run is the following:

```auto
PUT _transform/ecomm_210520
{
  "source": {
    "index": "kibana_sample_data_ecommerce"
  },
  "pivot": {
    "group_by": {
      "day": {
        "terms": {
          "field": "day_of_week"
        }
      }
    },
    "aggregations": {
      "sumprice": {
        "sum": {
          "field": "products.price"
        }
      },
      "sumquantity": {
        "sum": {
          "field": "products.quantity"
        }
      },
      "ratio": {
        "bucket_script": {
          "buckets_path": {
            "sumPrice": "sumprice",
            "sumQuantity": "sumquantity"
          },
          "script": "params.sumPrice / params.sumQuantity"
        }
      }
    }
  },
    "dest": {
      "index": "kibana_sample_data_ecommerce_transform_210520"
    },
    "frequency": "5m"
}

POST _transform/ecomm_210520/_start 

```

---

<div class="post-metadata">

**Author:** ![elisavet](https://avatars.discourse-cdn.com/v4/letter/e/258eb7/32.png) [@elisavet](https://discuss.elastic.co/u/elisavet)\
**Post date:** [May 21, 2020, 12:27pm UTC](https://discuss.elastic.co/t/transform-api-cant-find-destination-index-in-kibana/233732/2 "2020-05-21T12:27:51Z")

</div>

The solution I found is to create the destination index from the kibana UI. See instructions : [https://www.elastic.co/guide/en/elasticsearch/reference/current/ecommerce-transforms.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/ecommerce-transforms.html)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 18, 2020, 12:28pm UTC](https://discuss.elastic.co/t/transform-api-cant-find-destination-index-in-kibana/233732/3 "2020-06-18T12:28:00Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.