Compare two lines items from different modules

SofianeLz
SofianeLz
in Modeling

Hello

This is my problem.

I have a line item A in one module dimensioned by "Depense" list.
And I have the line item B in another module dimensioned by "Achat" list.

I want to compare if A = B then the item of the list Achat become the parent of the item of the list Depense.

I cannot pull any finditem.

Is there a way to do it ?

Thanks

Answers

  • Dikshant
    Dikshant

    you need to establish the mapping b/w both lists in order to compare it…

  • jagadishdash
    jagadishdash

    @SofianeLz Does both of your list "Depense" and  "Achat" having any relation? if not you have to meet the relation mapping between two as per your requirement.

  • SofianeLz
    SofianeLz

    @Dikshant @jagadishdash
    Thanks for the answers, indeed I need a mapping between them, but its hard to find any item in common between them, gonna look deeper

  • Dikshant
    Dikshant

    Oh may be I got your question now, you need to flag the items which are common in both list?

    Create a module and apply both lists as a dimension. Then create a Boolean and a formula to compare the codes or names of both the lists.

    NAME(ITEM(Achat)) = NAME(ITEM(Depense)) if both are flat list

    CODE(ITEM(Achat)) = CODE(ITEM(Depense)) if both are numbered list

    let me know if this is what you're looking for?

  • jagadishdash
    jagadishdash

    Above Dishkant's suggestions will work to create a mapping between two list with taking the both dimension.

    If that doesn't works, let us know the exactly what you're facing if possible with screenshots.

  • Jaintanya
    Jaintanya

    Hi, i have two modules with same line item. I want to compare if an item from one module is present in the line item in the other module. How can i do that? ITEM function is not working. I get this error that item only works with hierarchy.

  • seymatas1
    seymatas1
    edited June 21

    @SofianeLz

    Here are the step-by-step instructions on how I created a similar structure:
    1. I created List 1 and List 2.

    Screenshot 1: List 1

    image.png

    Screenshot 2: List 2

    image.png

    2. I created a presence mapping module, dimensioned by List 1.
    Screenshot 3: Presence Mapping Blueprint View

    image.png

    Screenshot 4: Presence Mapping Grid View

    image.png


    You can build a two-way comparison using the same logic. Let me know if this helps.

  • seymatas1
    seymatas1
    edited June 21

    @Jaintanya
    You can compare line items of two modules by creating line item subsets.

    Here is how I structured it:

    Screenshot 1: Module 1

    image.png

    Screenshot 2: Module 2

    image.png

    Screenshot 3: Line Item Subsets

    image.png

    Screenshot 4: LIS04: Line Item Comparison - Module 1

    image.png


    Screenshot 4: LIS05: Line Item Comparison - Module 2

    image.png


    Screenshot 4: Module 1 Comparison grid view

    image.png

    Screenshot 5: Module 1 Comparison blueprint view

    image.png

    Screenshot 6: Module 2 Comparison grid view

    image.png

    Screenshot 7: Module 2 Comparison blueprint view

    image.png

    I wanted to note that line item subsets are lists. You can use both ITEM() and FINDITEM() formulas on line item subsets.
    There could be a shorter solution if we could dimension a module by two line item subsets. We would create one module and dimension it by both line item subsets.

    Let me know if this helps.

Categories