3 Replies Latest reply: Jan 21, 2015 1:55 AM by Shyam Voleti RSS

    about drop field

    laicong zhang

      Hi

      I met a problem when i use drop field clause.

      the details is that:

       

      [fact table]:
      inner join ([Month table]) LOAD
           [Last Modified Date],
           Mid([Last Modified Date],4,2) as Month,
           Mid([Last Modified Date],7,4) as Year
      FROM
      [C:\Users\normal.xls]
      (biff, embedded labels, table is [Sheet 1$]);

      Drop field Month
      from
      [fact table];

       

      the script shows as above(just a piece of the script), when i load the data, an error message came up and said cannot find field Month in drop field clause.

       

      this confused me that though in the orignal data file it didn't exist, I created it in the script logic. Did this clause drop the field that should be exist in the data source? or I use it in a wrong method?

       

      Many thanks!!

       

      Br,

      Lisen