xlookup

Options
akprasa1
akprasa1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

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

Tagged:

Comments

  • akprasa1
    akprasa1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor

    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
    ogilkons Member, ALL USERS, GroupMember, Community Member Posts: 5 Contributor

    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" 

    ogilkons_1-1643709938651.png

     

    So then you can use formula for Identified column:

    Identified = Plant Settings. Identified [lookup: Plant]

     

    Hope that makes sense.

     

    Thanks,

    Nikolai

     

  • akprasa1
    akprasa1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor

    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
    akprasa1 Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor

    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.

Categories