This content has been marked as final. Show 3 replies
I met a problem when i use drop field clause.
the details is that:
inner join ([Month table]) LOAD
[Last Modified Date],
Mid([Last Modified Date],4,2) as Month,
Mid([Last Modified Date],7,4) as Year
(biff, embedded labels, table is [Sheet 1$]);
Drop field Month
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?