3 Replies Latest reply: Jan 15, 2011 12:39 PM by Chakravarthy MS RSS

    Reduce data

    MARCO HADIYANTO

      hi,

      i have data in qvd, from 2000 to 2010, i want to get data from 2007 to 2010, how can make this happen?

      i had try

      Load

      ..

      ....

      ......

      .

      from data.qvd where year>2006

      but only the date data type that were reduced and the other is like same before.

       

      any suggestion.

       

      thanks,

      Marco

        • Reduce data

          Hi Macro ,

          I didnot understood your query . Please clarify the following ..

          1) do u have only one qvd and when you are using the where condition, is the data not fetched according to the condition.

          2) Do You have more than one QVD and you have to reduce the data in all the other Qvds based on the condition in the year table .

          if you want o achieve the second query . you have to use the exists function on the key.

          Regards,

          Suman.