Target Matching
Target matching happens before the data is exported to the destination. Target matching is a useful feature in DataPrep that prevents export failures caused due to errors from the data model mismatch. Using target matching, you can set the required data as the target and align the source data columns to match with your target module fields. This ensures seamless export of high quality data to your destination.
Steps to perform Target Matching
1. When you try exporting data to destinations such as Zoho CRM, Zoho Creator, or cloud database a target from the destination's module is attached automatically to your current data and checks if the source matches with your target module fields. If the target match check passes, the data will be exported when the pipeline run completes. But if the target match check fails, the pipeline run will fail throwing a target match error in the Job summary page. However, you can fix the errors following the below steps.
2. The target's data model is displayed above the existing source. The columns in the source are automatically aligned to match the columns in the target, if found.
Target matching displays the different icons and suggestions on the matched, unmatched columns and error columns. You can click on these suggestions to quickly make changes to match the existing column with the target column.
3. You can also perform the following operations on the target choose one of the options below using the 
Target Matching icon:
- Refresh target - In case of any updates in the target, you can use this option and refresh the target.
- Pause target - This option will temporarily remove the target from the source.
- Resume target - Using this option you can resume the paused target.
- Hide target - This option hides the target data under the source.
- Show target - Using this option you can unhide the target if it is hidden.
- Remove target - This option permanently removes the target from the source.
5. All the columns in the source and target are displayed in the grid by default. However, you can click the All columns drop down and select an option to view specific columns such as Error columns, unmatched columns, etc.
Here are the available options,
All columns : All the columns, matched, unmatched, and mismatched columns in the source are displayed.
Error columns : This options shows all the columns from the source with errors after target matching.
Unmatched columns : This option shows all the unmatched columns in the source and target.
Note:
- The non-mandatory columns in the target can either be matched with a source column if available or ignored.
- If you have imported the source data from any source other than CRM, the additional columns present in the source will not be included during export by default. However, you can rename and match those columns if you want to include them.
- If you have imported the source data from CRM, the columns in the source that are missing in the target need to be matched or removed to proceed exporting. However, the additional columns(system-generated) columns will be ignored during the export.
When using the unmatched columns option, you can toggle the Show only mandatory columns option to see if there are any mandatory columns(set as mandatory in the target) and include them. You can also fix only the mandatory columns and proceed to exporting.
Data type mismatch : This option displays the columns from the source having data types that do not match the columns in the target.
Data format mismatch : This option displays columns from the source having date, datetime and time formats that differ from those in the target.
Constraint mismatch : This option displays the columns that do not match the data type constraints of the columns in the target. To know how to add constraints for a column, click here.
Mandatory columns mismatch : This option displays the columns that are set as mandatory in the target but not set as mandatory in your source.
Note: The mandatory columns cannot be exported to the destination unless they are matched and set as mandatory. You can click the 
icon above the column to set it as mandatory. You can also use the Set as mandatory (not null) check box under the Change data type transform to set a column as mandatory.
Data size overflow warnings : This option displays the columns with data exceeding the maximum size allowed in the target.
Note: The Data size overflow warning is only applicable to database targets.6. The View summary option appears once the target is attached. Click the View summary link to get an overview of the Target match errors on the unmatched columns and error columns.
- The Target match errors section shows the errors and the number of columns associated with each error.
- The section at the top lists the error categories along with the number of errors in each category.
- You can click them to filter errors related to each category in the panel.
- In the default view, all columns are displayed. However, you can click any error category and get a closer look at the columns or view the error columns alone by selecting the Show only errors check box.
- Your filter selection in the Target match errors panel will also be applied on the grid in the DataPrep Studio page.
For the unmatched columns filter, you can select the Show only mandatory columns checkbox to view only the mandatory columns.
FAQs
1. What should I do when the target match fails while exporting?
When your pipeline run fails due to target match errors, please do the following steps to fix them:
- In the Job summary page, click the Edit pipeline option on the top right corner. This will take you to the Pipeline builder page.
Note: Zoho CRM is shown in the screenshot for illustration purposes. The same will apply to all connectors and cloud databases.
b. Right click the last stage to which you’ve added the destination and choose the Prepare Data option. This opens the DataPrep Studio page.
c. Click the Target matching icon 
at the top right corner just above the data grid.
d. Choose the Show target option. This shows the destination module as the target and lets you align source columns to match it. Errors and warnings are highlighted with red and yellow icons.
e. Click the All columns drop down and choose Error columns option. Then click the red or yellow icons to match your stage columns with the destination module fields.
This adds the required data types and constraints to your stage columns so they match your target columns in your destination.
Note: The target columns from the destination are named as per the API names. So please make sure to name your stage columns the same way. This is required for the system to detect and rightly map the columns to your destination fields as per API standards.
Once target is successfully mapped with no more error columns, you’re good to proceed with running the pipeline.
2. What do the different icons displayed during target matching indicate?
The icons displayed during target matching indicate the status of column mapping and validation:
Grey icon → Additional columns present in the source will not be included for export.
Yellow icon (source and target columns matched) → The column can accommodate values exceeding the size limit in the target. Click to update constraints.
Yellow icon (column available in target but not in source) → This is not a mandatory column in the target. You can either match this column with a source column, if available, or ignore this warning.
Red icon → This is a required column in the target, but there are no columns left in the source to match. A matching column is required in your data.
Green icon → Target matched.
SEE ALSO
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Text and pattern matching
Zoho DataPrep supports the following text and pattern matching types. Text literals: Text literals are used to match the exact specified text in your data. Regular expressions: Regex are used to match data based on the expression provided. For ...Export data to Amazon RDS Oracle
Zoho DataPrep supports exporting data to Amazon RDS, a cloud database. Amazon RDS is also known as Amazon Relational Database Service and it helps to set up, operate, and scale databases. To export data to Amazon RDS Oracle 1. Open an existing ...Export data to Amazon RDS Maria DB
Zoho DataPrep supports exporting data to Amazon RDS, a cloud database. Amazon RDS is also known as Amazon Relational Database Service and it helps to set up, operate, and scale databases. To export data to Amazon RDS Maria DB 1. Open an existing ...Export data to Other Cloud Services - Oracle
Zoho DataPrep supports exporting data to Other Cloud Services like Oracle. Oracle is a relational database management system and it used for storing, organising, and retrieving data. To export data to Oracle 1. Open an existing pipeline or create a ...Export data to Other Cloud Services - PostgreSQL
Zoho DataPrep supports exporting data to Other Cloud Services like PostgreSQL. PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. To export data to ...
New to Zoho LandingPage?
Zoho LandingPage Resources