Get dates in different dimensions module

riyazpasha
riyazpasha
in Modeling

Hi,

 

I have a requirement to pull the dates in the module, the source and the target has different dimensions.

 

riyazpasha_0-1652806070278.png

 

Target module

 

Source module

riyazpasha_1-1652806121969.png

I want the dates basis on the revolver in the target since I can't use sum function on the dates to pull it any workaround for this use case.

 

 

Regards,

Riyaz Pasha

Tagged:

Best Answer

  • M.Kierepka
    M.Kierepka
    Answer ✓
    Hi @riyazpasha,
    Yes, you can't use lookup, you would use it in opposite situation. So in your source there can be many entries with the same Revolver - which one should be used? The one with the most recent/earliest date? Or the one that is visually the first/last entry in the table? It depends on your business case, so you need to pick from MAX/MIN/FIRSTNONBLANK/LASTNONBLANK aggregation functions. Then apply it just like you would apply SUM:, so i.e. Source.Date[MAX:Source.Revolver Name].

Comments

  • riyazpasha
    riyazpasha

    Hi @M.Kierepka 

     

    I got the idea I need to pick up the the max date for the particular transaction type. I have added some additional checks. Yep it worked.

     

    Still lot to learn. Thanks @M.Kierepka. Keep in touch

     

    Regards,

    Riyaz Pasha

    Regards,

    Riyaz Pasha

Categories