How can I lookup a line item in a source module ?

Hi, I am trying to pull in a column data (Status) from a module 13DL into the target module 8R.

LOOKUP didnt work for me. Help. What did I do wrong?

Target module :8R is dimensioned by P Project Data and line items

Source module: 13DL has a line item which has a list format of P Project Data ( derived from using Finditem formula). 13DL is dimensioned by DPMS and line items.

I am trying to pull text data from the Status column from 13DL to 8R. But get dimension error

Accepted answers

pyrypeura

It seems that you are trying to do LOOKUP wrong way round. You could do lookup from 8R to 13DL but not otherway round. Instead of LOOKUP you could use FIRSTNONBLANK or LASTNONBLANK summary functions if those suit your need.

HimanshuRaj

Hi @LimPhingHua

You use Lookup when you want to pick a particular data from a cell from source module, so lookup is generally applied for dimensions.

In your case, the field you are using lookup against is not a dimension, it's a line item.

So, instead of lookup, As Pyry mentioned you need to use Firstnonblank to pull the data in to avoid creating staging module for lookup

Cheers!!

All comments

asarna

Hi @LimPhingHua ,

Can you show me the Data view for the Finditem you've done? Also, the code you've mentioned doesn't seem to be correct.

Thanks,

Anmol Sarna

LimPhingHua

13DL

LimPhingHua

8R Dimensions

I am trying to fill in the MATR status (highlighted column in 8R :

From this MATR_Status column in 13DL:

pyrypeura

asarna

If there is a one-to-one mapping between 13DL and P Project Code, there should be no errors. However, if there are multiple lines for the same MATR_Status, an error will occur.

LimPhingHua

Actually its one to one mapping for 8R and 13DL. The display of 8R is showing like its has a many relationship…but actually the hidden code behind the display is unique …( the chosen display name isnt exactly ideal…..i inherited this existing list from someone else)

LimPhingHua

P Project data list with the hidden unique Code (although display name is may have repeats):

LimPhingHua

Both tables have another unique line item 'Reservation' as well.

P Project data list is just from a combination concatenation of Project elements-Reservation.

Do I have to resort to creating a staging module if this LOOKUP isnt working.

HimanshuRaj

Hi @LimPhingHua

You use Lookup when you want to pick a particular data from a cell from source module, so lookup is generally applied for dimensions.

In your case, the field you are using lookup against is not a dimension, it's a line item.

So, instead of lookup, As Pyry mentioned you need to use Firstnonblank to pull the data in to avoid creating staging module for lookup

Cheers!!

LimPhingHua

Hahah FIRSTNONBLANK solved it! I get it now, FIRSTNONBLANK act like a reverse LOOKUP if the source module has the dimension of the target module as a line item.

I have used FIRSTNONBLANK before as summary method on a line item within the same module with a hierarchy list dimension. But not like this.

Thanks..

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…