Get value of an item by lastDate

FARQLIK — Mon, 07 Sep 2020 13:07:54 GMT

Hello Community ,

I have an item I want to get the price By Dataaread(VMX/VTU) and for each Dataaread the last datecreation(MAX) in the load Script .

Thank you for your Help

Best Regards

Re: Get value of an item by lastDate

Kushal_Chawda — Mon, 07 Sep 2020 13:58:39 GMT

@FARQLIK try below

Data:
LOAD ItemNumber,
Dataaread
Date
...
....
FROM Table;

left join(Data)
load ItemNumber,
Dataaread,
max(Date) as Date
1 as Latest_Date_Flag
resident Data
group by ItemNumber,Dataaread;

Then on front you can write the expression for price as below

=Sum({<Latest_Date_Flag={1}>}Price)