# 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)

Vexdata can compare the selected source and destination tables to view: * *Cell Level Validation Results.* * *Record Count Validations* * *Source and Destination key Distributions.*