Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a function that allows you to take the most recent entry even if there is no date field?
Maybe LastValue()
check this out:
could you please add more details about your request?
Have a look at this article about Apply Mapping when reloading.
We've used this on a couple solutions to show the Reload Date rather than record creation date.
Makes checking logs easier!
So I am trying to see the last entry for the Field "Performance Values" there is a date function, but it has dates where there are no Performance Values so when I try to use set analysis to get the max(Date) it is generally zero because there is no entry for it. I would really like to just pull the most recent Performance measure value.
maybe this:
Sum( {< Date = {"=Max(Date)"} >} [Performance Value] )
Maybe use Where Not Exist in the new load and concatenate the table?
Table1:
Load
Key
ABC,
BCD,
Performance Value
From....Test1.qvd
Concatenate (Table1)
Load
Key
ABC,
BCD,
Performance Value
From UpdateTest1qvd
where not exists Performance Value;
I guess you'd need to store the Table1 into a qvd as a updateTable1.qvd and use that Update QVD to find any upated performance values?
I'm not sure if you looking for this in script or front end?
If In front end create a Rowno() as Record number and use Max (Record Number) in front end for performance
Maybe LastValue()
check this out:
With the apply map, the problem is that if I use any date filters it no longer works