Lookup from Different Dimension

Options
rachmitadhila
rachmitadhila
in Modeling

I have Source Module like below. It has SKU as dimension and line item "Exhibition Year Season" and "Exhibition Year". Both line item are using list formatted data type.

image.png

I want to lookup Exhibition Year in Target Module based on Exhibition Year Season in Source Module. So the result of target module will become like this:

image.png

I am using formula in Target Module like below:

I_Order Creation.'Exhibition Year' [LOOKUP: I_Order Creation.'Exhibition Year Season']

But it gets error : Format used for lookup doesn't match any dimension of the source.

Do you have suggestion how to resolve this?

Thanks in advance

Answers

  • 143kishornaidu
    143kishornaidu
    Options

    Hey @rachmitadhila .

    Try Using Firstnonblank or Last nonblank instead of Lookup ['Test 1'.Exhibition Year[FIRSTNONBLANK: 'Test 1'.Exhibition Year Season, FIRSTNONBLANK: 'Test 1'.'Item(SKU)']]

    Hope Its Helps

  • SriNitya
    SriNitya
    Options

    @rachmitadhila
    Try using FIRSTNONBLANK
    Formula Exhibition Year[FIRSTNONBLANK: 'Exhibition Year Season']

    image.png



Categories