-
ADO Blueprint View
Summary: In this lesson, we introduce the Blueprint view for an ADO transformation view. Audience: Model Builders, Integration Admins Lesson Duration: 3 minutes Updated: January 2025 Lesson Location: This micro-lesson is included Anaplan Data Orchestrator (ADO) training available in the Learning Center. Start the…
-
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 in the Anaplan…
-
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 in the Anaplan Data Orchestrator (ADO) training available…
-
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 Anaplan Academy. 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…
-
Use CAST to Change Data Type
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: 4 minutes Updated: July 2024 Lesson Location: This…
-
TO_DATE vs. CAST
Summary: The CAST function can be used to change the data type of a column from a string to a date, but the To_Date function provides more flexibility for converting text that represents different date formats in the input dataset. Let's compare the use of these two functions. Audience: Model Builders, Integration Admins…
-
Convert a TRUE String to a Boolean
Summary: In this short lesson, you'll learn how to change the data type of a column from String to Boolean. Audience: Model Builders, Integration Admins Lesson Duration: 2 minutes Updated: July 2024 Lesson Location: This micro-lesson is included in the Anaplan Data Orchestrator (ADO) training available in the Anaplan…
-
String Concatenation
Summary: In this short lesson, you'll learn how to use string concatenation to combine the contents of two ADO columns with the data type of String. Audience: Model Builders, Integration Admins Lesson Duration: 3 minutes Updated: July 2024 Lesson Location: This micro-lesson is included in the Anaplan Data Orchestrator…
-
Create Unique Identifiers with HASH()
Summary: The HASH function available in ADO makes it easy to create unique identifiers for data associated with a particular list member or combination of dimensions, such as an Account-Product combination. In this short lesson, you'll learn how to use HASH. Audience: Model Builders, Integration Admins Lesson Duration: 3…
-
Add a Detail Filter
Summary: You can use a Detail filter to eliminate rows from a dataset, based on criteria that you select. In this short lesson, you'll learn how to apply a Detail filter to a transformation view. Audience: Model Builders, Integration Admins Lesson Duration: 2 minutes Updated: July 2024 Lesson Location: This micro-lesson is…
-
Remove Duplicate Rows
Summary: Anaplan Data Orchestrator offers a quick way to remove duplicate rows of data from a dataset. This can be part of a data cleansing process, or it can be useful for creating lists of unique items. Audience: Model Builders, Integration Admins Lesson Duration: 3 minutes Updated: July 2024 Lesson Location: This…
-
Aggregate
Summary: In this short lesson, you'll learn how to use the Aggregate functionality to group data with a common dimension, such as Account, Product, and/or Time period. Aggregate returns an aggregation type that you specify, such as the sum, an average, or a count. Audience: Model Builders, Integration Admins Lesson…
-
Add an Aggregate Filter
Summary: In Anaplan Data Orchestrator, you can transform data with filters before or after aggregating it, but you must use the appropriate filter tool. Use an aggregate filter when you want to filter data that has already been aggregated in the transformation view. Audience: Model Builders, Integration Admins Lesson…