12 Replies Latest reply: Nov 23, 2016 12:30 AM by Marcus Sommer RSS

    Resident Load Error

    Rizwan Syed

      Hello Friends

      Below is my piece of code

       

      lTest:

      Load *,

      [Temp ID] as [New Temp ID]

      from lTest.qvd(qvd);

       

      MxTemp:

      Load * ,max([New Temp ID] as [New Temp ID]) ,[Orig Temp ID]

      Resident lTest group by [Orig Temp ID];

       

      The error  I am getting says field names must be unique within Tale.  This error pops up when about to load Temp. But If I want all my columns isnt Load * from resident the right way? Because I will be dropping the lTest Table and later will be fropping the MxTemp Table when I use it as a resident for another table.

       

      Thoughts?

       

      Thanks

       

      Rizwan