AnsweredAssumed Answered

auto-populate when importing into another table

Question asked by Imre... on Apr 5, 2014
Latest reply on Apr 9, 2014 by philmodjunk

Title

auto-populate when importing into another table

Post

     Hi,

     I'd like to populate a table with client-id's and their last-activity at the moment I import a file called "deliveries" which contains all id's and all their last-activities. (could be thousands of lines). 

     I know how to use the function "Max" in a calculation to find out which activity is the latest for the client.

     What I want to do is: create a table with only unique client-id's (PID) an their latest activity (max). 

     I appologize for maybe not being totally clear; i am dutch and try to be as precise as i can be. 

     tnx,

      

     In the screenshot you see six PID's (Person-id's, client-id's: 164062,164039 etc...) with their activities. 

     I'd like a tabel that only contains six id's (PID's) and the latest activity. 

     164062:22-01-2014 09:30

     164039:10-03-2014 09:00

     etc..

      

      

     OOoooorrrr...: how can I import only UNIQUE PID's with it's latest activity into my deliveries-table? (so: don't import if it is not the latest client-activity) WOW, if you could show me that, ...would be the best! tnx

Schermafbeelding_2014-04-05_om_16.04.15.jpg

Outcomes