8 Replies Latest reply: Nov 28, 2017 6:38 PM by Luis Madriz RSS

    Finding most recent date in qlik sense

    Amuktha Chakilam

      Hi all,

       

      I have two tables with calls data. The first table has id, phone number, call time stamp(MM/DD/YYYY hr min sec); Second table has phone number and time stamp(this time stamp is different from the one in table 1) but id is missing.

       

      How to look up the phone number from table 2 in table 1 and find id based on the most recent record of that phone_number in table 1?

       

       

      Table1.JPG

      Table 2.JPG

      I appreciate any help with this.

       

      Thank you