> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Compare Field

## TABLE OF CONTENTS

* [1. What is a Compare Field](#1.-What-is-a-Compare-Field)
* [2. Compare Field Options](#2.-Compare-Field-Options)
* [2.1 Name](#2.1-Name)
* [2.2 Unique Field for Compare](#2.2%C2%A0Unique-Field-for-Compare%C2%A0)
* [2.3 Compare Action](#2.3-Compare-Action%C2%A0)
* [2.4 Compare Field](#2.4-Compare-Field)
* [2.5 Compare Behavior](#2.5-Compare-Behavior)
* [3. Example and how to use it](#3.-Example-and-how-to-use-it%C2%A0)

---
### 1. What is a Compare Field

Compare field represents comparison by selected action on column.  
Because of operation complexity and time/resource consumption, values will not be visible in task preview.

**Important NOTE: To use Comparing fields, you will have to have a field that has a "Number" Value. This Field can be only created in CSV in source.**

### 2. Compare Field Options

Here are all the options for "Compare Field".

![](https://storage.crisp.chat/users/helpdesk/website/-/6/e/2/a/6e2ad965aec5b400/d507460d-3488-46bd-8112-51cae9_qhkpnk.png)

#### 2.1 Name

The Name of the custom field you would like to see in the Mapping section.

#### 2.2 Unique Field for Compare

The Field you would like to the other field field too in the Compare field.

#### 2.3 Compare Action

Compare fields and find minimum value or

Compare fields and find maximum value

#### 2.4 Compare Field

The Number field you would like to compare the original field with.

#### 2.5 Compare Behavior

Keep All rows and update their values depending on selected action **OR** Unset rows that have lower/greater value than **"Compare Field"**

### 3. Example and how to use it

**E.G. Compare field to get the lowest price based on an unique identifier SKU that is same by different Vendors.**

In this Example, we will be using lowest price, by using the Manufacturers SKU and comparing it to the "Price" ( Number data type) Field

With these options we are using the Lowest Value from all the Manufacturers SKU's and comparing it to the Price of that product.

Here are all the options we used for this example:

![](https://storage.crisp.chat/users/helpdesk/website/-/4/3/2/6/4326635715655c00/0ad0f163-d03b-4bb4-a9dc-7177e5_vjcxno.png)

After we have created the Compare field, we will map it with the **"Price"** Destination Field.

---

To check the list of the tools and features we support please click [here](https://syncspider.com/integrations/)!

If you don't see your favorite tool on our list, please take the time and send us the request [here](https://roadmap.syncspider.com/boards/integrations?sort=cached_votes_up) to create an integration for you or UP-vote if it's already on the list :)

We develop integrations based on the requests and up-votes :)

We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via [[email protected]](/cdn-cgi/l/email-protection#deadabaeaeb1acaa9eada7b0bdadaeb7babbacf0bdb1b3) or our chat widget!