6 Replies Latest reply: May 29, 2015 6:34 AM by Ramya Reddy RSS

    Loading only the newest data rows into Qlik

      Hi,

       

      I have the following data structure in my qvd:

       

      DateCompanyCEOe-mailPhone number
      Jan 2. 2014Comp AName 1XXX@compA.com000000000
      March 3 2015Comp BName 1XXX@compB.com111111111
      Jan 2. 2014Comp CName 2XXX@compC.com222222222
      March 3 2015Comp DName 2XXX@compD.com333333333
      Jan 2. 2014Comp EName 3XXX@compE.com444444444

       

      I would like to make a script that updates the company, e-mail, and phone number by loading only the newest information for Name 1 and 2, but keeps the information about Name 3 since i do not have any updates information about this person.

       

      The table i would like looks like this:

       

      DateCompanyCEOe-mailPhone number
      March 3 2015Comp BName 1XXX@compB.com111111111
      March 3 2015Comp DName 2XXX@compD.com333333333
      Jan 2. 2014Comp EName 3XXX@compE.com444444444

       

       

       

      Any suggestions of an easy way to do this in the script?