about drop field

[#1]

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

(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

[#2 · Accepted solution]

Hi Lisen,

According to the above script,the field Month belongs to the table [Month table],no table with name [fact table] exists as you have already joined it with [Month table].So if you want to drop the field "Month",then use this statement:

Drop field Month

from

[Month table];

[#3]

Hi Jemimah

thanks for your help, it works now

many thanks!

br,

Lisen

[#4]

Yes,

Jemimah Bag is true