xlookup

akprasa1

Hi All,

 

How do i do a xlookup in Anaplan?

 

I would like to have a Boolean identifier for the plant column based the locations in the rows.

Basically search the Loc 1 in the plant Column and give a true output against the plant for every occurrence.

Added module diagram for better understanding.

 

 

 

Thanks in Advance

akprasa1

Hi Manju,

Thanks for your response .

i am not trying to lookup based on a Boolean. The Boolean in the image is the expected result that i would like to have.

i am trying to search the Loc1 in the Plant Column and  expect a Boolean to be ticked against the Plant Column as identified.

 

 

 

 

ogilkons

Hi @akprasa1 ,

 

I am not sure I understand the purpose of Loc 1 column, so please correct me if I'm wrong.

I would suggest creating a new module with Plants as a dimension and a boolean line item named Identified (please see screenshot). Let's name this module "Plant Settings" 

 

So then you can use formula for Identified column:

Identified = Plant Settings. Identified [lookup: Plant]

 

Hope that makes sense.

 

Thanks,

Nikolai

 

akprasa1

Hi Kirill,

 

In the Image ,Plant column is a text formated ,the Loc 1 is also a text .

i want to search Loc1 -2350 in the Column Plant.If this search is successful,i should get a boolean ticked as shown in identified Column against every occurrence of 2350 in the Plant Column.

 

Hope this clarifies my question

akprasa1

These are Transaction data loaded. Plant column captures the Plant Names as text.

Loc 1 also captures a Plant Name.

Can we search the LOC1 Plant Name across the Plant Column and get the Boolean marked.