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

Understand Data Better by Creating Combination Pairs from Correlation Analysis

Stock portfolio analysis Flow The flow view of this template

correl, deduplicate, join, pivot, $filepath

This template flow shows how you can create combination pairs for correlation analysis from example stock performance data (that you can obtain by using one of the Yahoo Finance APIs). It makes use of Trifacta’s cross join capabilities as well as the correl transform.

The flow reads from a set of files in a specific folder that are parameterized. Each file represents performance data for a particular stock, the ticker of the stock is accessed via the $filepath variable. It then creates combination pairs of stocks for correlation analysis by cross joining against itself as well as date of the performance data. Finally to get to the correlation, it makes use of the correl transform function. You can use the techniques in this example flow for many other similar use cases.

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

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