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

2 REPLIES 2
Highlighted
Certified Master Anaplanner

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

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

Contributor

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

Hi @Kavin,

Thanks a lot, Made my day

Regards,
Usha