Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Only capture latest record in tmap

Hi,

 

I have a question please advise -

 

I am trying to output only latest record in tMap - for below example I only need 3/12/2019 record show in my output report. for now I can only catch all record or the first one. those input data are showing no sequence.

 

Thank you!

Trans DateTime record
3/11/2019 6:51 A
3/12/2019 10:43 A
3/11/2019 8:08 A
Labels (2)
11 Replies
DataTeam1
Creator
Creator

@vapukov  you're right. I didn't notice that there are first and last functions. Thx

DataTeam1
Creator
Creator

@szhou1 you can do this using tAggregateRow as @vapukov  mentioned.

 

You have to put all your columns to operation panel (not group by)

 

0683p000009M3Z7.jpg