Append
In DataPrep, you can append one dataset with another and create a new dataset using the Append transform. Here's a quick video on how to use the Append transform.
To append datasets
1. In the DataPrep Studio page, click the Transform menu, click Combine, then select Append.
Info: You can also click the 
icon or right-click the stage in the Pipeline builder and choose the Append transform.
2. In the Append dataset dialog, you can choose the dataset that you want to append to the current dataset.
3. Enter a name for the new dataset in the New dataset name box in the transform panel.
A new dataset will be created with the result of the Append transform.
4. DataPrep compares the column names of the two datasets and shows the unmatched columns so can choose to include or exclude them. For the matched ones, incoming data is added directly below the columns that have matched.
5. Click the Preview button and DataPrep will show a live preview of the append transform.
6. Click Append to apply the transform. Once you've successfully combined the two datasets by appending the rows, click Open the combined dataset.
7. If you want to edit the append configuration, you can open the Data source configuration from the Ruleset pane from the newly created dataset and edit the configuration.
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:
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?
Zoho DataPrep Resources
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
Dataset transforms
Dataset transform consists of combining and transforming datasets to suit your needs. You can apply the following transforms in a dataset. Deduplicate Row-wise Column-wise Join Append Pivot Unpivot Calculated columns Derive dataset Mark as personal ...Derive dataset
The Derive dataset transform allows you to create a branch of your dataset from the last applied transform in your dataset. The new dataset will have the most recent state of your data with an empty ruleset. To derive dataset 1. In the DataPrep ...Join
You can join two datasets together using common columns using the Join transform. For example, consider a dataset which has the purchase data of a store and another dataset with their customer information. These datasets can be combined using a ...Mark PII and ePHI data
You can mark a column that contains PII(Personal Identifiable Information) or personal data and ePHI (Electronic Protected Health Information ) data using the Mark PII and ePHI data transform. You can also apply security methods on the columns to ...Export data to Snowflake
Zoho DataPrep supports importing data from Snowflake, a cloud database. Snowflake is a cloud data warehouse that can store, process and analyze data. To export data to Snowflake 1. Open an existing pipeline or create a pipeline from the Home Page, ...
New to Zoho LandingPage?
Zoho LandingPage Resources