Comparing two modules

Hi - Because of a unique use case, we had to create two modules with similar information except a couple of columns. I want to compare if the data is correct in the new model. Can you please suggest on how I can do this ?

Sunl

Accepted answers

All comments

karank_*4578

Hi @sunilramakumar

Without going into too much details about your your use case i can think of few ways

if you are doing this in a very adhoc way then

download data from module 1 and module 2 into excel and use excel

if you want something within Anaplan then you can do it in 2 ways

create a third module to compare module 1 and module 2 line items ( not the best way)

another way is to use inbuilt compare functionality however you will have to change few things

create a list and add 2 members base 1 and base 2
apply this to your module. You only need 1 module as you can have different values by base 1 and base 2
use anaplan compare function and compare base 1 and base 2 using specific base

i can think of other ways as well like using subsets but will be great if you can list more information about your query .

hope this helps

Karan

sunilramakumar

Thanks Karan. In addition to the data the original module has some inbuilt formula as well. Is there a way we can compare if the formulas are the same ? I will check the data with the excel solutions that you have advised.

Sunil

karank_*4578

If it is adhoc then you can compare formulas as well using excel just extract modules in blue print mode

sunilramakumar

Thank you. I will check and will revert if there is any additional questions.

Quick Links

Can you help?

Unanswered questions

12_ [COMPLETE GUIDE] Uphold Support Number
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…