6 Replies Latest reply: Nov 22, 2011 5:25 AM by Sravan Puppala RSS

    Help needed in Load script

      Hi

       

      I am getting field not found error in my script. My script looks like this:

       

      LOAD

          *,

      if([Article Id] >= '42635' and [Article Id]<= '48733', [Quantity in stock]) as SS

      ;

       

      Stockvalue:

      LOAD

       

           art_id as [Article Id],

           attr2_id,

           qty as [Quantity in stock],

           price as [Stock price],

           rate

      FROM $(DIR_TRANSFORMATION)WeeklyStockValue.qvd (qvd)

       

      ;

       

      Now, when I reload, I get field not found <Article Id>. Can anyone help me, what am I doing wrong here? Please!

        • Help needed in Load script

          Try this:

           

           

          Stockvalue:

          LOAD

           

               art_id as [Article Id],

               attr2_id,

               qty as [Quantity in stock],

               price as [Stock price],

               rate

          FROM $(DIR_TRANSFORMATION)WeeklyStockValue.qvd (qvd)

           

          ;

           

           

          LOAD

              *,

          if([Article Id] >= '42635' and [Article Id]<= '48733', [Quantity in stock]) as SS

           

          Resident Stockvalue;