Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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)