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

Achieve High Quality by Removing Misaligned Data with Data Cleansing

Fixing misaligned columns of data Flow The flow view of this template

fill, delete, select

Do you ever have misaligned columns of data? This is a common data cleansing and quality scenario where columns of data are either shifted to the left or right from their intended position from the header or leading rows. This happens sometimes due to having ingested a printed or report view of the data.

This example template shows how you can fix such scenarios by using the fill transformation to fill up and down the rows and then filtering out any rows that have null values in those misaligned columns. You can leverage this technique to cleanse any shifted columns of data in your use case.

For more information, please see transformation function documentation for fill.

New to Trifacta?

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


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