10 Replies Latest reply: Feb 3, 2014 8:54 AM by Srikanth P RSS

    LOAD just distinct fields from one QVD and store into another qvd

      Hi Guys,


      I have a massive QVD which has around 200 Million records in it. I need to extract just the distinct key from this qvd. The key is just one field called CASE_NO. I've tried the following;


      Lets call the original QVD PAYMENT. I first loaded just the keys from this qvd into a table called FULL




      CASE_NO as CASE







      Distinct CASE_NO as KEY

      resident FULL;


      store DISTINCT_KEY into LOCATION\Distinct.qvd;


      The above works but for some reason Distinct.qvd contains ALL keys from the FULL.qvd instead of just the distinct unique ones.


      Any help will be appreciated!