If and lookup between lists and modules

Hello guys,

could some kind soul help me with this ?

i have two modules:

- module 1 : line item "account" list formated, list name is "group account" , line item "partner" list formated and list name is "partner"

- module 2 : line items are : - account the same as in module 1 but text formated

- group : list formated, list name is "transaction account"

- non group : list formated, list name is also "transaction account"

Now, what im trying to achieve is this : if the user select an account and a partner then lookup in module 2.group and show the line item corresponding; if the user only select account and partner is left empty then lookup in module 2.non group and fetch the non group item corresponding.

Hope that makes sense

Thanks 🙂

Accepted answers

himanshu.badhai

The logic would be something like this -

IF ISBLANK(mod1.partner) THEN mod2.non-group[lookup: ] ELSE mod2.group[lookup: ]

You'd also need an IF condition for case when both account and partner are blank.

Note: In-order to do a look-up, your module-2 needs to have the lookup lists as dimension

All comments

rob_marshall

@pdekas

In order to help, can you please let us know what modules 1 and 2 are dimensionalized by, as in what is the Applies To?

himanshu.badhai

The logic would be something like this -

IF ISBLANK(mod1.partner) THEN mod2.non-group[lookup: ] ELSE mod2.group[lookup: ]

You'd also need an IF condition for case when both account and partner are blank.

Note: In-order to do a look-up, your module-2 needs to have the lookup lists as dimension

pdekas

Hi ROB,
- module 1 is dimensioned by a numbered list called "Openings" and it has "company" as parent hierachy ( "company" is also a list line item in module 1).
- Module 2 is dimensioned
by a numbered list called "all group accounts", note that the list for the line item "account" in module 1 : "group account" is a subset of "all group account".
hope i was clear enough

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…