Get dates in different dimensions module

riyazpasha

Hi,

 

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

 

 

Target module

 

Source module

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.

 

 

M.Kierepka

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].