topic Field Not Found DETECT in QlikView

Field Not Found DETECT

Tue, 24 Apr 2012 14:38:11 GMT

Hi!

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

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

Something like: FieldExists (Field).

Can anyone help me?

Tks!

Marco

jagan — Tue, 24 Apr 2012 14:50:43 GMT

Hi,

Try this script

TableName:

LOAD

FROM ExcelFileName;

Hope this helps you.

Regards,

Jagan.

Tue, 24 Apr 2012 15:14:26 GMT

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 — Tue, 24 Apr 2012 15:37:22 GMT

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