Preppin Data — 2019W03

Key Learning

Other Operators apart from =, <> under join condition

Sample Input

Contract Details
Scaffold

Solution Steps

Make sure you use both sheets. Use one sheet to help you create a row of data for each month the person’s contract is ‘live’ for.

  • Tableau can create more columns but it cannot directly create rows. So, try to join the 2 sheets and generate more rows.
  • Now the contract length column is unnecessary and can be discarded.
  • Use the length column to generate each month from start date till last month
Calculation

I had to redo this calculation as I have initially missed the -1, as it signifies the start date.

Sample Output

Sample Output

Flow Snapshot

Flow Snapshot

Tableau Snapshot

Tableau Snapshot
Photo by J E W E L M I T CH E L L on Unsplash

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

3 Tips to Making Your Own Game

An easy way to experiment with CSS

Open Hardware Distribution and Documentation working group: Governing a central organization

Optimizing Transforms in DataStage with CoSort

Progress and Reflections

VEHICLE SIMULATION BASED ON ARTIFICIAL INTELLIGENCE

Hyperion — A PostgreSQL tool to dynamically test your queries

Spring Boot 2.x and Mocks

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jeevan Krishna

Jeevan Krishna

More from Medium

Overcoming Limitations in Creating Data Analytics Solutions

Google Provides the Best Data Journalism School — And It’s Free

Email — your friendly neighbourhood Analytics reporting platform (Part 2)

Introduction to Data Analytics