Community

Data Transformation and Aggregation

Plan Rocket
Plan Rocket Consulting 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
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.

Terms and conditions

Anaplan

Application Terms and Conditions: BY CLICKING TO PROCEED WITH DOWNLOAD OF THE APPLICATION, YOU ACKNOWLEDGE THAT THE TERMS BELOW SHALL GOVERN YOUR ACCESS AND USE OF THE APPLICATION. IF YOU DO NOT WISH TO BE BOUND BY THESE TERMS, DO NOT CLICK TO PROCEED. THIS APPLICATION IS NOT PROVIDED BY ANAPLAN, INC. AND THESE TERMS ARE NOT OFFERED BY ANAPLAN UNLESS ANAPLAN IS NAMED AS THE PROVIDER ON THE DOWNLOAD PAGE. USE OF THIS APPLICATION REQUIRES A VALID SUBSCRIPTION TO THE ANAPLAN HOSTED SERVICE, WHICH IS ONLY AVAILABLE THROUGH A SEPARATE AGREEMENT BETWEEN YOU AND ANAPLAN. Application Provider. The application named on the download page of the Anaplan App Hub (the “Application”) is provided by the party named on the download page (the “Application Provider”). Anaplan, Inc. (“Anaplan”) is not the Application Provider unless named as such on the download page. Terms and Conditions. This agreement (the “Terms”) contains the terms and conditions governing your use of the Application unless you have separately agreed to other terms with the Application Provider. These Terms are entered into solely between you and the Application Provider and shall become effective upon your download, access or use of the Application. Anaplan is not a party to these Terms unless it is the Application Provider. Grant of Rights; Anaplan Agreement. The Application Provider hereby grants you the nonexclusive, nontransferrable, nonsublicensable right to use the Application solely in connection with your authorized use of the Anaplan hosted service (the “Anaplan Service”). Your right to use the Application does not include the right to use the Anaplan Service, which requires a separate agreement between you and Anaplan (an “Anaplan Agreement”). You are not permitted to copy or redistribute the Application, but you may load the Application into your instance of the Anaplan Service and modify the Application in connection with your permitted use of the Anaplan Service. Evaluation and Production Use. Your right to access and use the Application is provided on a temporary basis and is limited to evaluation use for a thirty (30) day period beginning on the date of download (“Evaluation Period”). If your subscription under the Anaplan Agreement includes the right to use the Anaplan Service for the use cases covered by the Application, then you may use the Application for production purposes after the Evaluation Period, or earlier if the Application Provider agrees. If you do not have an Anaplan Agreement that includes your right to use the Anaplan Service for the use cases covered by the Application, then your right to access and use the Application will automatically terminate at the end of the Evaluation Period without notice from the Application Provider or Anaplan. Reservation of Rights. The Application contains valuable intellectual property rights of the Application Provider and you are not permitted to use or exploit such intellectual property rights except as explicitly permitted in these Terms. The Application Provider reserves all right, title and interest in the Application except for the rights explicitly granted to you in these Terms. Your right to use the Application will terminate immediately upon any breach of these Terms by you, or upon the termination or expiration of your Anaplan Agreement. Either party may terminate these Terms at any time in its discretion by providing the other party with notice, at which time your right to access and use the Application will terminate immediately.

Okay
© 2016 Anaplan, Inc. All rights reserved.

Existing customer

Sign in and select a workspace to instantly start using this app.

Sign in App Hub Privacy Policy

New to Anaplan?

You must have an Anaplan account to install this app.

Learn more
App Hub Privacy Policy

By clicking to proceed, you agree that Anaplan may collect data on your usage of the App and combine it with other information we have collected about you to improve services we offer you, and to improve the effectiveness of the App Hub. We may also contact you about your use of the App. Where an App is provided by a third party, we may share App usage data with that third party in which case that third party’s privacy policies will apply and this one will not. Please also see our Privacy Policy

OK