How to comapre Data from different Module and has Different Diemension

Hi,

I have a module A with List A, and Module B with List B. Both the Lists are almost similar. But they are 2 different List.

I have line Item PARENT_NODE in both Modules. I have new Line Item compare_Parent, were I need to compare and the result as "similar" or "different".

In ModuleB I have written below formula but its not working

IF PARENT_NODE = ModuleA.PARENT_NODE then "Similar" else "Different"

Please let me know on this

Thanks & Regards,

Asha

Accepted answers

kavinkumar

HI @usha.cherukuri,

All you need to do is, create a relationship between the 2 modules. Create a line item in Module B called 'List A' (Format: List ) and with the help of finditem() function derive the formula. If I understood correctly then your formula would be FINDITEM(LIST A, code(item(LIST )).

Then use look up function to derive your end result. It should be IF PARENT_NODE = ModuleA.PARENT_NODE[lookup:list A] then "Similar" else "Different"

I hope this helps!!

Regards,

Kavin.

All comments

kavinkumar

HI @usha.cherukuri,

Then use look up function to derive your end result. It should be IF PARENT_NODE = ModuleA.PARENT_NODE[lookup:list A] then "Similar" else "Different"

I hope this helps!!

Regards,

Kavin.

usha.cherukuri

Hi @Kavin,

Thanks a lot, Made my day 🙂

Regards,
Usha

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…