Compare two lines items from different modules
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
-
you need to establish the mapping b/w both lists in order to compare it…
0 -
@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.
0 -
@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 deeper0 -
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?
0 -
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.
0 -
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.
0 -
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
Screenshot 2: List 2
2. I created a presence mapping module, dimensioned by List 1.
Screenshot 3: Presence Mapping Blueprint ViewScreenshot 4: Presence Mapping Grid View
You can build a two-way comparison using the same logic. Let me know if this helps.0 -
@Jaintanya
You can compare line items of two modules by creating line item subsets.Here is how I structured it:
Screenshot 1: Module 1
Screenshot 2: Module 2
Screenshot 3: Line Item Subsets
Screenshot 4: LIS04: Line Item Comparison - Module 1
Screenshot 4: LIS05: Line Item Comparison - Module 2
Screenshot 4: Module 1 Comparison grid viewScreenshot 5: Module 1 Comparison blueprint view
Screenshot 6: Module 2 Comparison grid view
Screenshot 7: Module 2 Comparison blueprint view
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.
0