Contributor

## 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

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

## Re: How to comapre Data from different Module and has Different Diemension

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 B))).

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.

Regards,
Kavin.
2 REPLIES 2
Certified Master Anaplanner

## Re: How to comapre Data from different Module and has Different Diemension

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 B))).

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.

Regards,
Kavin.
Contributor

## Re: How to comapre Data from different Module and has Different Diemension

Hi @Kavin,

Thanks a lot, Made my day 🙂

Regards,
Usha