Compare two lists, one of it being numbered list

algrigore

Can someone advise me how to compare two lists, one of it being number list ?

Capture2_147804.PNG

Capture1_147804.PNG

Accepted answers

All comments

JaredDolich

@algrigore

Great question. By "compare" I'm assuming you want to find where they intersect and where they don't. In Anaplan two lists can easily be compared, numbered or not, but there has to be a module that relates them together. Here is a quick way to accomplish what you want.

Create a module using one of the lists.
Using the Code or the Name of the list item, use FINDITEM to locate it in the other list.
Create a Boolean that looks for ISBLANK on the FINDITEM line item. If it's not blank then you found a match, if it is blank then no match.
Repeat the module using the other list.
Once you have both modules set up, create filters on the items that didn't match so you can handle the outer joins if you need.

andrewtye

And if the numbered list doesn't have a code it's a bit tricker. You can look up in the non-numbered list but not the other way around.

In the FINDITEM formula will just need to reference the Display Name line item.

One way around no code in non-numbered is to have the module with both lists in it and have a line item that does numbered.display name = non-numbered.name(list) and then use that as a reference point with ANY as summary setting against the list modules.

Really make sure you've got codes in your lists!!

algrigore

Hi,

I did the steps until the Boolean part, I`m not sure how to use the formula.

Do you have an example?

Thnaks

Capture3_147837.PNG

andrewtye

So where the numbered list is dimensioned you won't be able to have name(item(list)) as the reference point as that will just return a number. Do you have a display name that you'll be able to use instead.

Then in the check it's a simple isblank(WBS element) formula

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…