• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Workday Adaptive Planning Tips & Tricks

Workday Adaptive Tips and Tricks: Data Integration and Creating a Join Table 

 

July 9, 2025

By Marc Assenza

Did you know that Workday Adaptive Planning integrations  allow you to create joined tables to be used as a source table in Adaptive?

It’s true! The process involves creating and defining the join between tables. You must have the proper credentials yourself within Workday Adaptive Planning to perform these steps.

Create the Join table Data Source:

From the Workday navigation button, go to Integration -> Design Integrations

Graphical user interface, application

Description automatically generated

You will arrive at the following screen.  Under the Component Library section click on the Data Sources option.

A picture containing text

Description automatically generated

From the list that is presented, the first option is to Create a new Data Source, select this.

Graphical user interface

Description automatically generated

Once clicked, the following list will be presented, select Table Group, give it a name, and hit the Create button. 

Graphical user interface, application

Description automatically generated

The Join table data source will be created; however, nothing has been defined yet regarding a table being joined, in essence, a shell has been created as seen below.

Graphical user interface, text, application, email

Description automatically generated

The next step is to define the Join table, this is done by selecting the Join Table option under the Custom Table folder and dragging and dropping the Join Table onto the Tables To Import pane.

Graphical user interface, text, application

Description automatically generated

When you drag and drop the Join Table onto the Tables To Import Pane, a new window opens asking you to define the Join itself.

Graphical user interface, text, application, email

Description automatically generated

Here you will give the table an actual name and assign the Primary table in the Join.

Graphical user interface, text, application, email

Description automatically generated

The next steps are to Add the joins to other tables and define the join expressions within, apply the changes and save the table.

Graphical user interface, text, application

Description automatically generated
Graphical user interface, text, application, email

Description automatically generated
Graphical user interface, text, application

Description automatically generated
Graphical user interface, text, application, email

Description automatically generated

The last steps are to select the columns you want to be part of the table and save the table again.

Graphical user interface, text, application, chat or text message

Description automatically generated
Graphical user interface, application

Description automatically generated
Graphical user interface, application

Description automatically generated

That’s all it takes to set up the Adaptive Data Source Join Table, now you’re ready to utilize it in the Staging area for integration however you see fit!

Revelwood is an award-winning, Platinum Solution Provider for Workday Adaptive Planning. We build solutions for the Office of Finance that minimize your risk by seamlessly incorporating business analytics into your everyday thinking. By combining the software with our best practices and out-of-the-box applications, we help businesses achieve their full potential with Workday Adaptive Planning.

Read more Workday Adaptive Planning Tips & Tricks:

Version Specific Transactions Drillthroughs

Spread Lookups

Forecast Explanations in Predictive Forecaster

Author

  • Marc Assenza

    View all posts
    • Categories

      • Accounting and Accounts Receivable
      • Awards & Recognition
      • Data Analytics in Finance
      • Financial Close & Consolidation
      • FP&A Done Right
      • IBM Planning Analytics Tips & Tricks
      • News & Events
      • Success Stories
      • Tech Bulletins
      • Workday Adaptive Planning Insights
      • Workday Adaptive Planning Tips & Tricks

    Popular Posts

    Authors

    Adam Riskin
    Adam Riskin
    Brian Combs
    Brian Combs
    Cameron Burke
    Cameron Burke
    Dave Miersch
    Dave Miersch
    Ivan Cepero
    Ivan Cepero
    John Pra Sisto
    John Pra Sisto
    Jonathan Dunn
    Jonathan Dunn
    Julia Seelin
    Julia Seelin
    Ken Wolf
    Ken Wolf
    Lee Lazarow
    Lee Lazarow
    Lisa Minneci
    Lisa Minneci
    Luke Griffie
    Luke Griffie
    Marc Assenza
    Marc Assenza
    Mary Luchs
    Mary Luchs
    Michelle Song
    Michelle Song
    Revelwood
    Revelwood
    Robert Nordhagen
    Robert Nordhagen
    Sarah Hildenbrand
    Sarah Hildenbrand
    Simon Foley
    Simon Foley
    Thomas McDade
    Thomas McDade

    Sign up for our newsletter

    Connect

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.