How to comapre Data from different Module and has Different Diemension

usha.cherukuri
usha.cherukuri
in Modeling

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

Tagged:

Best Answer

  • kavinkumar
    kavinkumar
    Answer ✓

    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.

Answers

Categories