Matrix Grid Help

Hi,

I currently have 2 entity lists (identical), and a module which maps the entity 1 list to entity 2 list. What I'm trying to do is to create a matrix with entity 1 as rows, and entity 2 in the columns (i.e. an entity matrix).

1. How do I create a formula which states if Entity in row = Entity in the column, select boolean?

Thanks!

Accepted answers

VIGNESH.M

Hi,

if both the lists are identical then try this,

NAME(ITEM('ENTITY LIST1')) = NAME(ITEM('ENTITY LIST 2'))

~VM

All comments

VIGNESH.M

Hi,

if both the lists are identical then try this,

NAME(ITEM('ENTITY LIST1')) = NAME(ITEM('ENTITY LIST 2'))

~VM

sean_culligan

There is another potential solution to this requirement. If you had a module which is dimensioned by Entity 1 and you wanted to find all the corresponding Entity 2 records (or vice versa), you could do this using the finditem function.

In your entity 1 module you would add a line item which is list formatted as Entity 2. Then use the formula:

Finditem(Entity 2, Name(Item(Entity 1)))

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…