Latest Record on Straight Table

[pljsoftware]

Hi all,

I have a record set with fields in images.

There are more [Id] and each Id have different [Element ID] and [Output Creation Date].

I need to create a straight table where show latest record for a each [Id], to check lastest record I test [Output Creation Date], but only for rows where [Message Type Name] =  TX.

The result can't be calculate in script because need to have latest for current selections.

I add QVW and Excel attach.

To check if result is correct the lines are in green and in Excel file you can find the sheet Result too.

Thanks in advance for your help.

Luca Jonathan Panetta

[sunny_talwar]

Check the attached (used FirstSortedValue) function

[pljsoftware]

Hi Sunny,

that could be a possible solution but I have more fields and I would, if possible, to don't create an expresson for each field. The number of fields enabled could be 50.

There is a possible solution with all fields in dimension and a single expression?

Thanks a lot.

Luca Jonathan Panetta

[sunny_talwar · Accepted solution]

Added the other option using if statement (expression is hidden on the presentation tab)

[pljsoftware]

Hi Sunny,

thanks a lot. I don't like "IF" but I think that in this case is the only way.

Thanks

Luca Jonathan Panetta