# COMPLETE result\_format not working on some expectations

**URL:** <https://discourse.greatexpectations.io/t/complete-result-format-not-working-on-some-expectations/1328>\
**Category:** GX Core Support\
**Created:** [August 15, 2023, 2:51pm UTC](https://discourse.greatexpectations.io/t/complete-result-format-not-working-on-some-expectations/1328 "2023-08-15T14:51:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![erman](https://avatars.discourse-cdn.com/v4/letter/e/94ad74/32.png) [@erman](https://discourse.greatexpectations.io/u/erman)\
**Post date:** [August 15, 2023, 2:51pm UTC](https://discourse.greatexpectations.io/t/complete-result-format-not-working-on-some-expectations/1328/1 "2023-08-15T14:51:34Z")

</div>

Hello Everyone,  
I want to have the complete result of my validations and not just the basic. I run the following code to modify the checkpoint and then run it.

```auto
checkpoint = gx.checkpoint.SimpleCheckpoint(
            name=f"{asset_name.replace('/', '_')}_test",
            data_context=context,
            validations=[
                {
                    "batch_request": my_batch_request,
                    "expectation_suite_name": expectation,
                },
            ],
            runtime_configuration={
                    "result_format": {
                        "result_format": "COMPLETE",
                        "unexpected_index_column_names": ["column:1", "KID"],
                        "return_unexpected_index_query": True,
                        "include_unexpected_rows": True
                    },
                },
        )

        print("running expectations on: ", asset_name)
        checkpoint.run()

```

However I have noticed in the validation.json output, that it doesn’t create the COMPLETE result format for every expectation. My expectation suite has 3 expectations and looks like this:

```auto
{
  "data_asset_type": null,
  "expectation_suite_name": "Exp_1",
  "expectations": [
    {
      "expectation_type": "expect_column_values_to_be_unique",
      "kwargs": {
        "column": "column_1"
      },
      "meta": {
        "notes": {
          "content": "For testing purposes. **Markdown** `Supported`",
          "format": "markdown"
        }
      }
    },
    {
      "expectation_type": "expect_column_distinct_values_to_be_in_set",
      "kwargs": {
        "column": "column_1",
        "value_set": [
          "Kat 2: Pauke",
          "Kat 2: Grosse Trommel",
          "Kat 2: Kleine Trommel",
          "Kat 2: Becken",
          "Kat 2: Triangel",
          "Kat 2: Steeldrum",
          "Kat 3: Trompete",
          "Kat 3: Tuba",
          "Kat 3: Posaune",
          "Kat 4: Piccolofl\u00f6te",
          "Kat 4: Klarinette",
          "Kat 4: Saxophone",
          "Kat 4: Sousaphone",
          "Kat 5: Dudelsack",
          "Kat 6: Mikrophone",
          "Kat 6: Verst\u00e4rker",
          "Kat 6: Lautsprecher",
          "Kat 7: Minibus 9 Pl\u00e4tze",
          "Kat 7: Minibus 14 Pl\u00e4tze",
          "Kat 8: Anh\u00e4nger Minibus"
        ]
      },
      "meta": {
        "notes": {
          "content": "For testing purposes. **Markdown** `Supported`",
          "format": "markdown"
        }
      }
    },
    {
      "expectation_type": "expect_column_values_to_be_unique",
      "kwargs": {
        "column": "KID"
      },
      "meta": {
        "notes": {
          "content": "For testing purposes. **Markdown** `Supported`",
          "format": "markdown"
        }
      }
    }
  ],
  "ge_cloud_id": null,
  "meta": {
    "great_expectations_version": "0.16.16"
  }
]

```

The complete result is being generated however for “expect\_column\_values\_to\_be\_unique” but not for “expect\_column\_distinct\_values\_to\_be\_in\_set”.  
Is there something specific I need to write in the expectation suite for that expectation?  
OS\_VERSION: Ubuntu 22.04  
GX\_VERSION: latest (edited)

---

<div class="post-metadata">

**Author:** ![jpcampbell42](https://avatars.discourse-cdn.com/v4/letter/j/838e76/32.png) [@jpcampbell42](https://discourse.greatexpectations.io/u/jpcampbell42)\
**Post date:** [August 15, 2023, 3:14pm UTC](https://discourse.greatexpectations.io/t/complete-result-format-not-working-on-some-expectations/1328/2 "2023-08-15T15:14:40Z")

</div>

Since you’re providing an index, I’m guessing you are looking for the primary key of each row that does not have its value from your set. In that case, you may want to use `expect_column_values_to_be_in_set` instead of `expect_column_distinct_values_to_be_in_set`. `expect_column_distinct_values_to_be_in_set` will only provide the aggregate result by design – it looks at distinct values _first_ and then compares to the value\_set.