Lookup funtion return blank values

joky1980
edited November 2022 in Modeling

Hi,

I have the 2 modules below and did a lookup function but it returns blank values.

Am i missing something?

joky1980_2-1669865603209.png

joky1980_3-1669865705952.png

Best Answer

  • ManjunathKN
    edited November 2022 Answer ✓

    @joky1980

    - Create 1 line item in SYS01 with name of Accounts code, Format - list, Accounts code, Formula - Finditem(Accounts code list, Code)
    -In mapping to countries line item use this formula - SYS05. distributor[lookup: New line item(Accounts code)]

    Thanks,
    Manjunath

Comments

  • ManjunathKN
    edited November 2022

    Hi @joky1980 ,

    Code is Line item in sys01 but a list item in Sys05. I think it must be different list, if so, do a finditem in SYS01 to derive the list of sys05 list in sys01. Lookup or firstnonblank should work here.

    Thanks,
    Manjunath

  • joky1980
    edited November 2022

    Hi @ManjunathKN ,

    The code from SYS01 is code that was from the list.

    Can you kindly advise how i can get the value (Distributor) from SYS05?

    joky1980_1-1669878417494.png

    joky1980_3-1669878485445.png

  • ManjunathKN
    edited November 2022

    Hi @joky1980,

    Cant really relate by this. Can you show me the blueprint view of Sys01 and sys05. SS should have "applies to".

    Thanks,
    Manjunath

  • joky1980
    edited November 2022

    Hi @ManjunathKN ,

    As below blue prints;

    joky1980_1-1669879065025.png

    joky1980_0-1669879024355.png

  • joky1980
    edited November 2022

    @ManjunathKN, it works! thank you very much!