5 Replies Latest reply: Jan 4, 2013 11:22 PM by Jonathan Love RSS

    Create qvd

    Jonathan Love

      What am I doing wrong here?  Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items;  Store Local_Individual_Items INTO  C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd

        • Re: Create qvd
          Jonathan Love

          OK, So this loads the file Cost_Centers into QVW, but does not create the QVD  Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Cost_Centers;  Store Cost_Centers INTO  C:\Program Files\QlikView\LOCAL\Local_Cost_Centers.qvd (qvd);    SQL SELECT * FROM dw_DataMart.dbo.Dim_Cost_Centers;

          • Re: Create qvd
            Nagaian Krishnamoorthy

            Try the following:

             

            Cost_Centers:

            LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items; 

             

            Store Cost_Centers INTO  C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd (qvd);

              • Re: Create qvd
                Jonathan Love

                These are the errors I received:  Cannot open file 'C:\Users\uslovjon\Desktop\dw_DataMart.dbo.Dim_Individual_Items' The system cannot find the file specified.  Cost_Centers: LOAD * FROM dw_DataMart.dbo.Dim_Individual_Items    Table not found Store Cost_Centers INTO  C:\Program Files\QlikView\LOCAL\Local_Individual_Items.qvd (qvd)