# Compare Report

Validating and comparing the provided two data sources.\
These are the validation checks performed during comparison:

* Duplicates identified in Source
* Duplicates identified in Target
* Missing records found in Source when compared to Target
* Missing records found in Target when compared to Source
* Column-wise comparison performed
* Row-wise comparison performed

***

## Column-wise Comparison

Comparison performed for each column between Source and Target.\
Each field is compared individually to identify matching and mismatching values.

### Sample Output

| transactionid | accountbalance\_Source | accountbalance\_Target | accountbalance\_Match | accountid\_Source | accountid\_Target | accountid\_Match | currency\_code\_Source | currency\_code\_Target | currency\_code\_Match |
| ------------- | ---------------------- | ---------------------- | --------------------- | ----------------- | ----------------- | ---------------- | ---------------------- | ---------------------- | --------------------- |
| TX000001      | 449874.48              | 449874.48              | TRUE                  | AC00128           | AC00128           | TRUE             | INR                    | INR                    | TRUE                  |
| TX000002      | 1210784.08             | 1210784.08             | TRUE                  | AC00455           | AC00455           | TRUE             | INR                    | INR                    | TRUE                  |
| TX000003      | 98766.8                | 98766.8                | TRUE                  | AC00019           | AC00019           | TRUE             | INR                    | INR                    | TRUE                  |
| TX000004      | 754077.28              | 754077.28              | TRUE                  | AC00070           | AC00070           | TRUE             | INR                    | INR                    | TRUE                  |
| TX000005      | 653787.2               | 653787.2               | TRUE                  | AC00411           | AC00411           | TRUE             | INR                    | INR                    | TRUE                  |
| TX000006      | 68787.84               | 68787.84               | TRUE                  | AC00393           | AC00393           | TRUE             | INR                    | INR                    | TRUE                  |
| TX000007      | 1171870.48             | 1171870.48             | TRUE                  | AC00199           | AC00199           | TRUE             | INR                    | INR                    | TRUE                  |

***

## Row-wise Comparison

Comparison performed for the entire row between Source and Target.\
The complete record is evaluated, and the result indicates whether the row fully matches or not.

### Sample Output

## Row-wise Comparison

### Sample Output

| transactionid | accountid | transactionamount | transactiondate | Source | Row\_Match |
| ------------- | --------- | ----------------- | --------------- | ------ | ---------- |
| TX000001      | AC00128   | 1239.92           | 11-04-2023      | Source | TRUE       |
| TX000001      | AC00128   | 1239.92           | 11-04-2023      | Target | TRUE       |
| TX000002      | AC00455   | 33109.12          | 27-06-2023      | Source | TRUE       |
| TX000002      | AC00455   | 33109.12          | 27-06-2023      | Target | TRUE       |
| TX000003      | AC00019   | 11113.52          | 10-07-2023      | Source | TRUE       |
| TX000003      | AC00019   | 11113.52          | 10-07-2023      | Target | TRUE       |

***

## Report Download

All comparison result files are available for download.

![Compare-report](/files/oY61i8164Eg1vqfamnul)


---

# 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.qyrus.com/data-testing/reports-and-results/index/compare-report.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.