Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Wrangle Summit 2021 On Demand

You can still experience the best people, ideas and technology in data engineering, all in one place

Get All-Access Pass
 
All Templates

Use Source to Target Mapping to Transform a Source Dataset to Match a Target Dataset’s Schema

Mapping to a target schema Flow The flow view of this template

Easily transform data using a mapping table between source and destination datasets

Transformations:
join, pivot, rownumber

This template allows source to target mapping t to a target dataset’s schema using a mapping table. The mapping table specifies which columns in the source should be mapped to columns in the target, as well as the final ordering of the columns in the target.

To make use of this template, simply swap out the input_customers.csv dataset with your own input dataset, as well as the columns_mapping.csv with your own mapping table. Note that both the input dataset and the mapping table are expecting the first row of the dataset to be a header row with column names, like most Excel files.

New to Trifacta?

Sign up below to our free 30-day trial to use this template.

SIGN UP FOR FREE TRIAL

Already have an account?

Download template (Trifacta version) and import it on the Flows page.

Is your data on Google Cloud?

  1. Download template (Dataprep version)
  2. Launch Dataprep on Google Cloud
  3. Import it on Flows page

Learn more about Dataprep

How to Import