Field Not Found DETECT

[#1]

Hi!

I have an excel file that until a certain date was not a specific field, which was included after this date.

Before	After
CodID	CodID
Name	Name
Depto	Depto
Manager Name	ManagerID
	Manager Name

How can I use the same script to load these files?

Something like: FieldExists (Field).

Can anyone help me?

Tks!

Marco

[jagan]

Hi,

Try this script

TableName:

LOAD

*

FROM ExcelFileName;

Hope this helps you.

Regards,

Jagan.

[#3]

In the load script I manipulate the fields and also have a track record to be loaded.

My first idea was to verify the date of file generation and load have two scripts, one for each period. Maybe it's more correct to do.

[vincent_ardiet]

Hi Marco,

You can have a look to the following functions FieldName, FieldNumber and mainly NoOfFields.

The last one gives you the number of fields in a table.

Regards,

Vincent