-
Create a Transformation View
Summary: Creating a transformation view is a key step in the ADO data flow from source data to target models. Learn how to create a transformation view in this lesson. Audience: Model Builders, Integration Admins Lesson Duration: 3 minutes Updated: July 2024 Lesson Location: This micro-lesson is included Anaplan Data…
-
Transform Order and the Transformation View Toolbar
Summary: Data in a transformation view can be manipulated and readied for use by applying one or more transforms to it. In this short lesson, we will introduce the transformation view toolbar and cover the important topic of transform order and its implications for producing transformation views and transform pipelines.…
-
Reselect Columns from a Primary Dataset
Summary: You can add more columns from a primary dataset to an existing transformation view. See how it's done in this lesson. Audience: Model Builders, Integration Admins Lesson Duration: 2 minutes Updated: July 2024 Lesson Location: This micro-lesson is included Anaplan Data Orchestrator (ADO) training available in…
-
Join and Union
Summary: Anaplan Data Orchestrator allows you to combine data from different datasets in a transformation view using either a Join or a Union. In this short lesson, you'll learn the difference between these methods and explore when to use each one. Audience: Model Builders, Integration Admins Lesson Duration: 5 minutes…
-
Use Join - Lookup
Summary: Join Lookup adds new columns to a primary dataset when the join key matches in the join dataset. All rows from the primary dataset are retained, and any rows without a match in the join dataset will have a NULL value in the resulting dataset. Learn how to execute a Join Lookup in this short lesson. Audience: Model…
-
Use Join - Inner Join
Summary: Inner join adds new columns to a primary dataset when the join key matches in the join dataset. Records from the primary dataset will only be included when there is a record with a matching join key in the join dataset. Learn how to execute an Inner join in this short lesson. Audience: Model Builders, Integration…
-
Use Union to Add Data
Summary: When you combine datasets in a transformation view using Union, you add new rows to the primary dataset. In this short lesson, you'll learn how to execute a transform with Union. Audience: Model Builders, Integration Admins Lesson Duration: 4 minutes Updated: July 2024 Lesson Location: This micro-lesson is…
-
Add a Column
Summary: In Anaplan models, you add line items when you want to create new calculations. In Anaplan Data Orchestrator, you add columns instead. Audience: Model Builders, Integration Admins Lesson Duration: 1 minute Updated: July 2024 Lesson Location: This micro-lesson is included Anaplan Data Orchestrator (ADO) training…
-
Rename a Column
Summary: In this short lesson, you’ll learn how to rename a column in a transformation view. Audience: Model Builders, Integration Admins Lesson Duration: 1 minute Updated: July 2024 Lesson Location: This micro-lesson is included Anaplan Data Orchestrator (ADO) training available in the Learning Center. Start the…
-
Calculate a Column (Add a Formula)
Summary: CAST is a handy function that you can use in Anaplan Data Orchestrator to change the data type of a column in a transformation view. In this short lesson, you'll learn how and when to use CAST. Audience: Model Builders, Integration Admins Lesson Duration: 3 minutes Updated: July 2024 Lesson Location: This…