3 Replies Latest reply: Nov 14, 2017 4:36 PM by Vishwarath Nagaraju RSS

    Incremental issue

    Manu Sharma

      Hi all,

       

      I am new to qlikview , i am practicing incremental load but after putting where condition i am getting a error field not found.

       

      Can any one help please?

       

      Pfa the files attached.

       

       

      Regards

      Manu

        • Re: Incremental issue
          m w

          Don't see any Where clause in your script.

          • Re: Incremental issue
            Vishwarath Nagaraju

            Try this

            change the paths accordingly with your excel sheet and QVD paths.

             

            Sales:

            LOAD Customer,

            [Sales Order ID],

            Date#(ShipDate,'DD-MM-YYYY') AS ShipDate,

            Product,

            Sales, Quantity

            FROM [..\Desktop\RoughForum_Files\Sales Orders .xls]

            (biff, embedded labels, table is [Sales Orders$]);

             

             

            Temp:

            LOAD MAX( Num#(ShipDate)) as MaxDate

            Resident Sales;

             

            let vMaxDate = Peek('MaxDate',0,Temp);

             

             

            TRACE >>> $(vMaxDate);

             

            Store Sales into C:\Users\VNAGARAJ\Desktop\RoughForum_Files\Sales.Qvd(qvd);

            DROP Table Sales;

             

             

            Sales2:

            LOAD Customer, [Sales Order ID], ShipDate, Product, Sales, Quantity

            FROM [..\Desktop\RoughForum_Files\Sales Orders .xls] (biff, embedded labels, table is [Sales Orders$])

            where [ShipDate]>> $(vMaxDate);

             

            Concatenate

            LOAD Customer, [Sales Order ID], ShipDate, Product, Sales, Quantity

            FROM C:\Users\VNAGARAJ\Desktop\RoughForum_Files\Sales.Qvd (qvd);