Data Transformation and Aggregation

AnaplanAppHub
Not applicable
Spaulding Ridge has created a guide for using the LEFT, RIGHT, MID, DATE, FINDITEM, and SUM functions in relation to aggregating raw data. This app will help users as they work to make data transformations to better suite their Anaplan modeling needs. Common uses include disaggregation of codes, identifying specific numbers within dates, and mapping codes to other lists.

Information

App Last Updated
April 15th, 2016
Size
1 MB
Language
English
Terms & Conditions

App stats

Modules
6
Roles
1
Formulas
10
Reports
8
Complexity
Intermediate

 

 

Features

Learn How and When to Use the LEFT Function
  • In this dashboard you will learn how to use the LEFT function to extract a text substring from an account line item.
Learn How and What to Use the RIGHT Function
  • In this dashboard you will learn how to use the RIGHT function to extract a text substring from an account line item.
Learn How and When to Use the MID Function
  • In this dashboard you will learn how to use the MID function to extract a text substring starting from any position in the original text.
Learn How and When to Use the DATE Function
  • In this dashboard you will learn how to use the DATE function to convert numbers into a usable date format.
Learn How and When to Use the FINDITEM Function
  • In this dashboard you will learn how to generate a list formatted item from extracted text.
Learn How and When to Use the SUM Function
  • In this dashboard you will learn how to sum values from a line item using one or more mappings.

Spaulding Ridge

Spaulding Ridge offers executive-level, practical advice to scale your business. Whether it’s defining your company’s strategic plan, developing growth strategies, or unlocking innovation through cloud investments, Spaulding Ridge helps our clients navigate through their most challenging and critical decisions. We leverage our expertise across industry, finance, and technology to deliver tailored solutions and exceptional outcomes.

 

Website
http://www.spauldingridge.com
Address

Chicago, IL

Email
jay@spauldingridge.com