# ETL Testing/Cell By Cell Compare

This compare option will compare the data, or columns, of the source and target tables on various checks.

To create a *Cell By Cell Compare* flow:

* Drag a *Source* component from the palette to the canvas.
* Choose the *Input Source Configuration* and select the tables to compare.
* Drag a \_Target \_component from the palette to the canvas.
* Choose the *Input Source Configuration* and select the tables to compare
* Drag a *Data Compare* component and join the connections.
* Select *ETL Testing/Cell By Cell Comparison* from the drop-down menu that appears at the bottom of the screen.
* Select the primary key. By default, the primary key is selected for the tables. If the key is not selected, the system shows a warning sign for the user to select the *Primary Key*.
* Save and execute the flow.

[Data Compare Options](https://app.gitbook.com/@Vexdata/s/docs/flows/untitled-1/compare-cell-by-cell/cell-by-cell-compare/sql-transformation)

<figure><img src="/files/7Vqcd43NcoOyDX255QdV" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/CgyORRniYUbdpx0uSXCB" alt=""><figcaption></figcaption></figure>

Vexdata can compare the selected source and destination tables to view:

* *Cell Level Validation Results.*
* *Record Count Validations*
* *Source and Destination key Distributions.*

<figure><img src="/files/0kmFvlzLIRycdr3aD7IU" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/eR2WpDoGVKLRbTQjw2AL" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.vexdata.io/designing-and-executing-flows/flows/untitled-1/compare-cell-by-cell/cell-by-cell-compare.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.