// This file is autogenerated, DO NOT EDIT
// Use `node scripts/generate-docs-examples.mjs` to generate the docs examples

[source, js]
----
const response = await client.transform.putTransform({
  transform_id: "ecommerce-customer-transform",
  source: {
    index: ["kibana_sample_data_ecommerce"],
    query: {
      bool: {
        filter: {
          term: {
            currency: "EUR",
          },
        },
      },
    },
  },
  pivot: {
    group_by: {
      customer_id: {
        terms: {
          field: "customer_id",
        },
      },
    },
    aggregations: {
      "total_quantity.sum": {
        sum: {
          field: "total_quantity",
        },
      },
      "taxless_total_price.sum": {
        sum: {
          field: "taxless_total_price",
        },
      },
      "total_quantity.max": {
        max: {
          field: "total_quantity",
        },
      },
      "order_id.cardinality": {
        cardinality: {
          field: "order_id",
        },
      },
    },
  },
  dest: {
    index: "ecommerce-customers",
  },
  retention_policy: {
    time: {
      field: "order_date",
      max_age: "60d",
    },
  },
});
console.log(response);
----
