8 Replies Latest reply: Aug 16, 2015 7:38 AM by Sunny Talwar RSS

    Temp table not dropped

    Khairul Anuar Azuddin

      Hi guys

       

      Consider the following script:

       

      ProjectDate_Temp:

      CrossTable(DTP, Data)

      LOAD ProjectCode,

           [41761],

           [41768],

           [41775],

           [41782],

           [41789],

           [41796],

           [41803],

           [41810],

           [41817],

           [41824],

           [41831],

           [41838],

           [41845],

           [41852],

           [41859],

           [41866],

           [41873],

           [41880],

           [41887],

           [41894],

           [41901],

           [41908],

           [41915],

           [41922],

           [41929],

           [41936],

           [41943],

           [41950],

           [41957],

           [41964],

           [41971],

           [41978],

           [41985],

           [41992],

           [41999],

           [42006],

           [42013],

           [42020],

           [42027],

           [42034],

           [42041],

           [42048],

           [42055],

           [42062],

           [42069],

           [42076],

           [42083],

           [42090],

           [42097],

           [42104],

           [42111],

           [42118],

           [42125],

           [42132],

           [42139],

           [42146],

           [42153],

           [42160],

           [42167],

           [42174],

           [42181],

           [42188],

           [42195],

           [42202],

           [42209],

           [42216],

           [42223],

           [42230],

           [42237],

           [42244],

           [42251],

           [42258],

           [42265],

           [42272],

           [42279],

           [42286],

           [42293],

           [42300],

           [42307],

           [42314],

           [42321],

           [42328],

           [42335],

           [42342],

           [42349],

           [42356],

           [42363],

           [42370],

           [42377],

           [42384],

           [42391],

           [42398],

           [42405],

           [42412],

           [42419],

           [42426],

           [42433],

           [42677],

           [42445],

           [42454],

           [42461],

           [42468],

           [42475],

           [42482],

           [42489]

      FROM [lib://Data/Project.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      ProjectDate:

      LOAD 

            Date(Num#(DTP),'DD-MM-YY') as ProjectProgressDate,

            ProjectCode,

            AutoNumberHash128(Date(Num#(DTP),'DD-MM-YY'),ProjectCode) AS ProjectDateKey

      Resident

          ProjectDate_Temp;

       

      DROP Table ProjectDate_Temp;

      After loading data, when viewed in the Data model viewer, seems like the ProjectDate_Temp table is still there:

       

       

      Which is kind of confusing to me. Can somebody point out what is the problem here?

       

      Thank you for your kind attention guys

       

       

      Edited:

       

      Added my qvf file for your kind reviews. Thanks guys