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

       

      FULL:

      load

      CASE_NO as CASE

      FROM

      [LOCATION\FULL.qvd]

      (qvd);

       

      DISTINCT_KEY:

      load

      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!

       

      Thanks